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.