AnsweredAssumed Answered

Table Relationship

Question asked by GreggMccombs on Feb 28, 2013
Latest reply on Feb 28, 2013 by GreggMccombs


Table Relationship


     Should be an easy one - I have 2 tables, a customer table and and employee table.  The customer table is related to the employee table through the employee id number, a unique number assigned to each employee.  When I am in the customer table, in input the employee number and it populates employee information associated with that customer.  My need is to have a 2nd employee, in certain situations, that has aidid with that customer.  How can I enter a 2nd employee id number in the customer table and get the 2nd employee name and associated data?  Thank you.