Access DB design - Employees/Supervisors

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.
 
V

Van T. Dinh

Check Access Help on Many-to-Many relationship. In your case, it sounds
like you want a self-join Many-to-Many relationship.
 
Top