table relationships and the query

  • Thread starter Thread starter one1george
  • Start date Start date
O

one1george

Hello,
i have a one to many relationship in my db.
i can add two related tables to query and get data but
when i add a third related table to the query design the
query will only return column heads and no data?
It seems to be able to handle two related tables and
deliever data but not three related tables.

does anyone have an idea why,
i can't find anything to help with this problem

thanks
 
I have Queries that use 7-8 Tables that return rows
without any problems.

If you have the Column / Field headings, that means the
Query runs fine (according to the relationships & criteria
you set in the Query) but there is no rows returned.

You will need to check the joins / relationships you set
in the Query. If you have any criteria, remove them for
join-testing.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top