You could use two fields in Customer to hold two IDs from Employee. Each could link to a different occurrence of the Employee table.
Or you can set it up as a full many to many relationship with a join table between customer and ID. This second option would allow you to link any number of employees to any number of different customers.
Employees 1-------<Customers>------Employees 2
Customers::_fkEmployeeID1 = Employees 1::__pkEmployeeID
Customers::_fkEmployeeID2 = Employees 2::__pkEmployeeID
Customers::__pkCustomerID = Employee_Customer::_fkCustomerID
Employees::__pkEmployeeId = Employee_Customer::_fkEmployeeID
With option 2, you'l place a portal to Employee_Customer on the Customers layout to link a customer to different employees.
For an explanation of the notation used in this post, see the first post of this thread: Common Forum Relationship and Field Notations Explained
Thank you - option 1 is what I have been trying to get to work. I have an employee id in Employee table (ID 1), then I have a 2nd employee ID (ID 2)which is a calculation = to employee ID 1. Are you suggesting that I do not need a 2nd ID number in the employee table, but use a 2nd ID number in the customer table, then create a duplicate table in employees? Sorry if this seems simple. Thanks.
Thank you - I have resolved the issue. Your links to notation led to another link and I solved it. Very much appreciated!