Select record of 3rd child table in portal
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
I figured out, that the selection of the Company in the Portal works, because I set the option "Allow record creation" in the relationship between the JOINTABLE and the COMPANY table. So if I select the Company, it creates a new Company record.
Sorry, I'm a filemaker newbie.