Little Problem

[lab18]

I cant get my queries to work. Queries for single tables i have no problem, but when I include another table, I dont get any records. Im thinking it has to do with relationship but not sure i tried every type of relationship with no luck. Needless to say Im new at Access, so any help will be welcomed.
Thanks

 

[Rich]

A little more detail on your structure might be helpful and prevent us from guessing answers

 

[cogent1]

If you're not getting any data, it's because there is a join between your tables and one of the tables doesn't contain any related records.

The default join is really a way of saying "Show me records that have corresponding (eg) Customer IDs in BOTH tables ". If you investigate joins you will see that it is possible to show data from either table, even if there are no related records : useful if you want to find CUSTOMERS who haven't placed ORDERS for example.