Relationships

[ccordner]

Think I've titled this right.

I have a table for all our staff, with names & addresses etc. I also want to include who their manager is.

Is it possible to have a field, "Manager", which looks up values from the same table or do I have to have a separate table for managers?

Thanks
Chris

 

[jackd]

Yes, you use the same table.
Suppose your table is Employees. Each employee has a unique Id (empId)
You have a new field in this table called Manager.
The contents of Manager is the empId of the Manager of this Employee.


Jim empId 3
Joe empId 16
Jane empId 7

Jane is the Manager of Joe and Jim, so records in the table have these among other values.
Jim empId 3 Manager 7
Joe empId 16 Manager 7
Jane empId 7 Manager NULL


An Employee with Manager NULL is a "Grand Poobah" /"executive"/"Top dog"