Trouble with a many to many relationship

Jeanette

Registered User.
Local time
Today, 05:13
Joined
Dec 17, 2001
Messages
52
Hi, I have a many to many table relating a Contractor's table to a project's table. There is a third field Ownertype with a list of three choices:Contractor, Owner, or Owner/Contractor. Is there someway to create a query if a project has a contractor and owner without duplicating the records. In the same query I want one field to have only Contractors and another field to have Owners. I hope this is not to confusing. Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom