I have an employee table setup as below
_KP_Serial ID (Unique auto-enter)
Junior Manager Employee No
Senior Manager Employee No
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