I’m sure this has been asked and answered before, but I cannot find an answer.
I have 4 tables: 1)Contacts, 2)Contacts2, 3)Programs, and 4)Projects.
Contacts & Programs are connected by Fields: C_program_name & PM_program_name. In ProgramsLayout, I have a script (button) that opens ContactsLayout, Go to Field [C_program_name], Set Field [$$PM_program_name]. Thus connecting the 2.
Contacts2 & Projects are connected by Fields: C_project_number & PJ_project_number. In ProjectsLayout, I have a script (button) that opens ContactsLayout, Go to Field [C_project_number], Set Field [$$PJ_project_number]. Thus connecting the 2.
I want a Portal in ProjectsLayout and ProgramsLayout that lists the contacts from both. In other words, when I open ProjectsLayout, I would like to see contact names that are associated with Projects Table, as well as Programs Table.