last table killing me

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Query 1 is composed of four tables. I need to add one field from a fifth
table and join it with three fields from that table, one of which is a
one-to-many. I can't even add the table to Query 1 without getting an
ambiguous join error. I can add the table in a 2nd query and join all three
fields one-to-one. However, when I change the one-to-one to one-to-many, no
go.

Any help?
 
Query 1 is composed of four tables. I need to add one field from a fifth
table and join it with three fields from that table, one of which is a
one-to-many. I can't even add the table to Query 1 without getting an
ambiguous join error. I can add the table in a 2nd query and join all three
fields one-to-one. However, when I change the one-to-one to one-to-many, no
go.

Any help?
Click to expand...

You'll sometimes need to do this in two stages. Create a query of two
or three of the tables (I'd suggest the pair with the outer join), and
save it; then create the real query by joining the other tables to
this query.

If this isn't making sense, please post your table names and how you
want them joined.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top