4 Replies Latest reply on Dec 3, 2015 1:39 PM by mikebeargie

    How to display information from two join tables

    brian47933

      Hi all. I am fairly new to FM and need some guidance.

       

      I have a solution that tracks instructors to classes. I need to track Main Instructors and Support Instructors for each class.

       

      Originally we had a one to one relationship between class and main instructor. On the class layout there was a portal showing the support instructors (using a join table as this was a many to many).

       

      Things changed and now I need to have both main and support instructors as a many to many. They need appear on the class layout inn a portal so we can identify which instructors were the main instructors and which ones were the support instructors.

       

      I originally tried creating a new join table pointing to the same instructor table. This didn't work. It show the same instructor information in both portals.

       

      Now I think it may come down to a self-join relationship? Am I on the right track?

       

      Thanks in advance for any help.

       

      Brian