I have tables for Companies and Contacts (companies can have multiple contacts). Companies can be customers, partners (suppliers), or both, so they are in the same table. I have an "Action" layout and table, and want to be able to select both a customer and a supplier with a contact for each from a dropdown list (lookup table keyed to the ID but showing name), with other fields showing the name of the company and contact.
Just can't get the relationship working for the second relationship (the contact) for the supplier. Have added table occurrences Company Partner and Contact Partner and additional keys, but can't figure it out.
Please see screenshots of the layout and relationships.
Any help appreciated.