I have 3 tables one with dogs names, one with dogs breed names, and one with
the purchasers of the dogs. I need to make a query that shows the purchasers
last and first names, thier dogs names and thier dogs breed names. How do i
do this as a query.
Your tables need to have some sort of joining fields which you don't
specify - i.e. your Dogs table needs a Breed or BreedID field as a
link to the Breeds table, and an OwnerID field to indicate who owns
the animal. If you have such fields, add all three tables to the Query
design window. Access should (if you've defined relationships between
the tables) it should automatically create join lines. You can then
select whichever fields you want to see.
If you don't have relationships, or don't have linking fields, then...
well, you need linking fields and you need relationships; you're using
a database, after all, and these are essential elements.
John W. Vinson[MVP]