AnsweredAssumed Answered

Relationship query

Question asked by ebj on May 18, 2018
Latest reply on May 18, 2018 by philmodjunk

Hello Filemakers gurus!


This one has had me stumped for some time. I have to 2 tables - Contacts and Quotations. There is a basic relationship between the two (primary key/foreign key), allowing you view a contact's quotation summary within a portal contained on the Contacts Table layout.


On rare occasions, I would like 2 contacts to be related to the same quotation. For the avoidance of doubt, I would like the same quotation summary to appear within a portal on 2 contacts.


It sounds like it should be straightforward, yet I cannot seem to find an elegant solution.


Any ideas?