How to join multiple Emp ID fields on same form to Emp table

[mitchem1]

I have a form that is used to enter contract information. One of the fields is Employee ID -- the employee who worked on the contract. It is joined to the Employee ID column of the Employee table. Simple enough. However, sometimes 2 or more employees work on a contract, so I need multiple Employee ID fields and am unsure how to join them properly to the Employee table. Thanks very much in advance.

 

[chrismcbride]

You have two tables in a many to many relationship - Employees can work on one or many Contracts and Contracts can employ one or many Employees. This means you need an intersection table - ContractWorker (maybe). This table resolves the many to many by storing unique combinations of contact id's and employee id's.
Once you have this structure then you can make a data entry form based on the contract table and a sub form based on ContractWorker.
HTH
Chris