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