I have a form that is created from multiple queries. In the form specific relationships, I have two tables, Events and Registration. I also have a query SupervisorName.
They contain the following pertinent fields:
Events
EmployeeID
Registration
EmployeeID
SupervisorName (Query)
EmployeeID...