AnsweredAssumed Answered

Show related record of a related record in a portal

Question asked by camberol on Jun 7, 2014
Latest reply on Jun 10, 2014 by Stephen Huston

I have 3 tables:

 

Companies

Contacts

Phones

 

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)

 

Greg

 

Message was edited by: camberol

Outcomes