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.