In message , Rachel
writes
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.

As others have already pointed out, the answer is to create a link
table. I'll just add that it's worth taking some time to look at what
the link table actually represents. You may find that there is more to
it than just the keys to its two parents.



--
Bernard Peek