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
Please refer to the image below for additional instruction.
Last modified: 2019/03/21