I have a table Work which has two columns, SupeID and EmpID. This specifies the supervisors and the employees that work for them.
and so on
There is a table called Person that contains ID and FirstName, LastName for each person that is in the Work table. SupeID and EmpID are both IDs from the Person table.
I would like a form where the top of the form would have the SupeID and their name and then there would be an embedded subform which would have a list of their respective EmpID with names.
I'm a little stuck right now because I'm getting both sets of IDs from the Work table instead of two separate tables.