table relationships and the query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

one1george - 30 Aug 2004 21:21 GMT

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

Reply to this Message

Van T. Dinh - 31 Aug 2004 00:38 GMT

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)

>-----Original Message-----
>Hello,
[quoted text clipped - 10 lines]
>thanks
>.

Reply to this Message