Wrecking my brain trying to grasp what i think is a case for query relationship.
The case is assigning instructors to groups.
I have three tables:
On the layout with Groups context I need a portal showing:
- All Instructors that aren’t "assigned" to this group.
“Assigned” means that GroupsInstructors contains a records where:
- GroupsInstructors:fkGroupsID = Groups:pkID
- GroupsInstructors:fkInstructorsID = Instructors:pkID