AnsweredAssumed Answered

How to display information from two join tables

Question asked by brian47933 on Dec 3, 2015
Latest reply on Dec 3, 2015 by mikebeargie

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.