AnsweredAssumed Answered

Select record of 3rd child table in portal

Question asked by MrBond on Apr 12, 2015
Latest reply on Apr 12, 2015 by MrBond

Title

Select record of 3rd child table in portal

Post

Hi!

I have four tables "Applicant", "Job history", "Company" and "Contact Person". Each Company has many contact persons. Each applicant has only one contact Person in one Company per Job. In the layout of "Applicant" I have a Portal of the "Job history" records, where I wanna choose the Company AND the Contact Person in that company. I have made a join table between "Job history" and "Company" and put the field "companyName" of the table "Company" in the Portal of "Job history", so I can choose the Company. But how can I choose the "Contact Person" related to the Company selection? Any ideas?

My ERD till now: 
APPLICANT --<  JOB HISTORY --< JOINTABLE >-- COMPANY --< CONTACT PERSON

Outcomes