An Easy Query Question(Hopefully)

[TheDeal56]

I've posted this on another forum, but I'm not getting any help on it. Let me know if I need to explain it in more detail.

I have one table containing a list of addresses:

Address
1301 Main St.

I have another table containing names :

Name 1
John

I have yet another table containing names:

Name 2
Chris

The primary key for the address table matches up with the primary keys in the name tables. I need to write a query that will pair the addresses in the address table with the names from each of the name tables. It should look like this:

Address..................Name
1301 Main St. .........John
1301 Main St. .........Chris

Can anyone help? Thanks.

 

[Uncle Gizmo]

the open the query builder, add the address table and only "ONE" of the name tables, link the two tables on the unique ID, pull all the fields in to the query grid, and then select make table and make a new table.

do exactly the same with the other "name" table creating another table.

now appened the two tables together.

 

[TheDeal56]

Thanks for the fast reply; that works out great.