Setup a many-to-many with a join table as follows:
Instructors --<- InstructorClasses ->-- Classes
In the InstructorClasses table, create a "role" field.
The role field will define a main or support instructor. Ideally, you can use this for substitute, support and alternate instructor roles as well later on.
In your portal for the class, make the portal based on the InstructorClasses table, pulling info from the instructors table, and showing the role. You can also filter the portal based on role = "main" or role = "support".
Thank you, Mike.
Your solution makes perfect sense. I must have been trying to make it more difficult.
Mike, thanks again. I just completed the steps you outlined and it worked exactly as needed.
Great! multi-to-multi relationships always warp things a bit.