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

    How to display information from two join tables


      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.