is there a way to find out which exact record lies behind Table Relatation Field via FieldRef?
I want to be able to find out every record related to any given record.
In many cases this could be done via a .Get() command, since many related tables have a single field Primary Key: Just get the Table ID via FieldRef.Relation, open a RecordRef on said table, find out which one the PK-Field is and set a filter.
But what if I have a field which is related to a table which has several fields in PK.
Say I have a table which contains a field, related to "Sales Header"."Document No.".
Now I want to find out, for a record of said table, to which exact record my Table Relation field points.
I hope this question doesn't read like gibberish to you. In my head it all makes sense but to write it down came out to be pretty difficult.
Thanks in advance and Best Regards!
PS: If the category is unfitting, please tell me! I didn't really know where to place it.