I have to perform certain business logic based on the value of a field on a table.
Table1.FIeld1 we will call it. Field1 is a RefRecId in reference to:
Table2.RecId.
On the form that Table1 is a datasource for it shows as Table2.Name.
The table and field can be dynamic but I need to be able to:
Look at Table1.Field1 and find what table the recId is referencing.
FInd the record in Table2 based on that recId and some how get to the Table2.name value. I believe this is set up through the replacement key index.
Is there a way to do this through X++ code? I've been playing around with dictRelation, dictField class but not seeing any methods that get me anywhere.
Thanks
*This post is locked for comments