Access DB design - Employees/Supervisors

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Hi all,

Hoping someone can help. I want to setup the following relationship:

--Employees, which can be supervisors or non-supervisors, may have one
or more supervisors. Supervisors may also manage one or more
employees.--


I appreciate any insight you can offer. Thanks.
 
Check Access Help on Many-to-Many relationship. In your case, it sounds
like you want a self-join Many-to-Many relationship.
 
Back
Top