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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
table relationship in query 1
Query shows no results when using 2 tables with multiple relations 3
Query and relationships 4
Query with one to many relationship 2
Limit relationships for a field 2
table relationships and the query 1
Problem: query from two tables connected to a third table 2

Back
Top