Info from more than 2 tables in query

[Guest]

I have a table than joins several other tables and it consists mostly of
AutoNumber records. The query gets the results I want, but displays them as
AutoNumbers. Whenever I try to add another table to get meaningful
descriptions I get an error of either Left or Right Join errors.

How do I do it?

Thanks.

 

[Allen Browne]

When you use outer joins, Access puts arrow heads on the line joining the
tables in the upper pane of query design. If you are getting "ambiguous
outer join" messages, try to get all arrows pointing away from the lowest
level table.

Post more detail if that's not enough.

 

[Guest]

Thanks, I had figured it out, but the arrow heads from the lowest table put
it in a way I hadn't considered.

Thanks.