8 Replies Latest reply on Apr 2, 2015 7:18 PM by ChrisSweet

    Need to link employees to the managers and senior managers.

    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