I am trying to create the following relationship between records in the same table:
I have a table called CONTACTS.
I have a Linked Record Field called CUSTOMER which links to the same CONTACTS table (Multiple choice is activated).
For Contact A I select Contact B in the CUSTOMER field.
In return I want the the AGENT field for Contact B to automatically display Contact A.
How do I format the AGENT field to do that?
Thank you for your help!