Combining Queries?

[Dave Titan]

Hi Folks,

I have the following:

these two are related;
tbl Contacts
tbl Contact details

this one is independant;
tbl outsiders

I need a query that will display all selected contacts from all tables. However when trying this I can get details from the first two tables, but if I add the third table (tble outsiders) into the query I get mass duplication?

I have tried making a query for each table, this works. I then tried making a third query to pull all the information from the two new queries I created but end up geting not a single record displayed?

Do I need to set a relationship up for this tbl outsiders into the query? if so how do I set this. I am afraid I fall down miserably when it comes to relationships.

The end result of all this should be a report based on certain criteria from all three tables.

Any help much appreciated,

Dave

 

[Brianwarnock]

I don't understand why the information from the outsiders table should be included in the same report as the contacts if there is no logical relationship, surely separate reports are needed?

Brian

 

[Dave Titan]

Outsiders are needed as they are a table of different (non work) people some of whom have a work common ground with the people in the other two tables.

I need to pull off a report that match certain criteria from the people in the related tables tbl Contacts tbl Contact details and the table out on it's own tbl outsiders.