0 Replies Latest reply on Oct 27, 2015 5:07 AM by BrentJohnson

    combining same table occurences in portal

    BrentJohnson

      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.