query with relationships

[ian422]

Hello everyone, as you may have guessed i have a problem

so i have a table with a one to many relationship with another table...everything's cool except when i want to query data it will query fine from one table or another but i really want to return data from the related tables as well.

simple question i know but i cant seem to figure it out

helpppp

 

[jzwp22]

Can you provide a little more detail about your table structure and the text of the query you are trying to use?

 

[dsfcom]

If you have a main table with related records in other tables that you can key from using a unique identifier (i.e. Autonumber, concantenation of data, etc.) simply edit the relationship in query design to "Show All Records from bla bla bla table and show related records from bla bla bla table". Do this for all the sub-tables then all the records from your main table will appear and only those having related records from the sub-tables will appear (you'll see the blanks if there are no related records in the sub-tables). Make sure the "show all records" table is your main table and you should be good to go.

 

[ian422]

Worked like a charm thanks guys