I am trying to model marital relationships in TFP. Here is my simplified schema: “People” form with “Name” field, “Marriages” form with “Person1” and “Person2” fields. This works great and People finds all the Marriages records tied to the first field (“Name” to “Person1”). However, Marriages records do not show up in the People form record for Name linked to Person2. Can the Marriages form be linked to the Persons form via two foreign keys (Persons.Person to Marriages.Person1 and Marriages.Person2)? If this relationship is possible, it seems likely a script will be needed to show all Marriage records related to a People record – that would be fine.
Hi Rob,
My sincere apologies for taking so long to respond.
Are you using the Join Link Type or the Many to Many Link Type?
With a Join Link Type you can’t link via multiple fields, but you can create a compound field using a Calculation field or a Script field to join two fields’ values together and then join on that field.
You may also want to turn on the Show Inverse Relationship option so you can see the relationship from both sides.
Thanks,
Brendan
.
