Join Query Problem

[karen]

I tried to do a query to display info from 4 tables. I
went to the middle of the line (relationship line) right
clicked and chose Join with option #2.

I do this with all tables..is this right?

What ends up happening when I run the query is I get a
message stating my query is to ambiguous and to do one
query and then use that to do another?? What does this
mean?

When I don't join any of the tables I get 0 data.

HELP!
Thanks in advance.
Karen

 

[Jeff Boyce]

Karen

The use of the #2 and #3 options is only when you need to see "ALL of table1
and ANY of table2 that match". Note that if you set selection criteria on
table2 in your query, Access (I believe) treats the join as if it were NOT
directional (i.e., as an "option#1").

So the correct answer, ... is a question! What data do you have in what
tables, and what are you trying to "retrieve"? Without knowing that, it'll
be a little tough to guess how, if at all, you should be using the 4 tables.

Good luck

Jeff Boyce
<Access MVP>