You need three tables:

TblProject
ProjectID
etc

TblCustomer
CustomerID
etc

TblProjectCustomer
ProjectCustomerID
ProjectID
CustomerID

For data entry you need a form/subform. The main form would be based on
TblProject and the subform would be based on TblProjectCustomer. In the
sobform you need a combobox (or listbox) to enter CustomerID. The row source
for the combobox (or listbox) would be TblCustomer.

Steve





"Rachel" wrote in message
...
I have a Projects Table and a Customers Table. My problem is I want to have
multiple Customers on one project and I want each customer to be able to
have
multiple projects. I don't know how to set up the tables and relationships
to
do this.