AnsweredAssumed Answered

combining same table occurences in portal

Question asked by BrentJohnson on Oct 27, 2015

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.

 

Outcomes