This content has been marked as final. Show 1 reply
You can have as many relationships between the same two tables as you need. You just need some extra "boxes" on your relationships tab that all refer to your contacts table to make this happen.
- Click Contacts to select it
- Click button number 3 at the bottom (It as two green plus signs). And you'll get a new "table occurrence" for contacts. Drag from Backup Site Contact to Contacts 2::Contact ID and you'll have a link for your backup site contact. You don't have to leave this table occurrence with a name like Contacts 2, you can double click the box and give it a more descriptive name if you wish.
- When you want to add fields for the Backup Site Contact to a layout, select the fields from Contacts 2 (or whatever you choose to name it) instead of Contacts.
- Repeat the process for the remaining two relationships.