Hi,

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!

Tobias