How to Build Parent-to-Parent Table Links

To create a Parent-to-Parent relationship between two tables, complete the following steps

Create each of the table that will be party to the relationship

Open the Table Management Window for the table that is the relating (origination) table in the relationship. This is the table that is “asking the question”.

Click on “Create Table Reference” at the bottom of the objects library section on the far right side of the table management screen

Click and hold your mouse over the table that is to be the “other party” or the related table in the relationship. While holding your mouse button, drag that table into the fields section (middle column) of the Table Management window and release the mouse