relationships and queries

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

one1george

Hello,

I have a one to many db design..
when i add two related tables to a query i
get data
when i an a third related table i only get
column heads?
i am using access 97

any ideas?

robin
 
Hi Robin,

When designing queries based on multiple tables, it is
very important to pay close attention to the type of
joins that you are using. If you have a table that has
one to many relationships to two other tables, your
result set may be blank if you have inner joins between
the two other tables (Inner joins are the default unless
you have defined something different in the relationships
window). This is because it will only return records
that have a match in both tables. On the other hand, if
you choose outer joins, you can return all records from
one table, and only the matches from another (or
others). To set the type of join in the query builder,
double-click the join line between the tables and select
the appropriate join type between each table.

HTH, Ted Allen
 
Back
Top