Query relationship

Discussion created by user2147316 on Mar 30, 2018
Latest reply on Apr 2, 2018 by philmodjunk

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:

Groups —=GroupsInstructors=—Instructors


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