user2147316

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

Outcomes