I have 3 tables:
Companies::ID = Contacts::parentID
Contacts::ID = Phones::parentID
Companies::ID = Phones::gparentID
Contacts and Phones have a primaryField set to auto-enter 1 if it is the first record created that is related to another record by the parentID.
Only 1 Contact can be selected as a primary for each Company.
Only 1 Phone can be selected as a primary for each Contact.
How can I show the primary Phone for the primary Contact in Companies?
How can I show the primary Phone for each Contact in a portal in Companies?
Is it possible that the only way to show the primary Phone for the primary Contact in Companies is to add a child field to Companies for the ID of the primary Contact and add Companies::primaryChild = Contacts::primary as an additional condition of the relationship?
Is there a better or simpler way?
Any advice would be appreciated.
(I have uploaded two picture to help)
Message was edited by: camberol