AnsweredAssumed Answered

Need to link employees to the managers and senior managers.

Question asked by ChrisSweet on Apr 1, 2015
Latest reply on Apr 2, 2015 by ChrisSweet

Hi guys.

I have an employee table setup as below

 

_KP_Serial ID (Unique auto-enter)

Employee No

Junior Manager Employee No

Senior Manager Employee No

Employee Name

Department

Job Position

 

I need to show the name of the Junior Manager and the name of the Senior Manager and since all the records are in the same table I'm trying to create a self relationship and link the junior manger number to its own record and the senior manager to its own record,  but can't get it to work..

 

Any ideas please !!  Can I have 3 primary keys in one table ? or is there another way of doing it. 

 

Thanks in advance

Outcomes