Query with one to many relationship

  • Thread starter Thread starter Dudley
  • Start date Start date
D

Dudley

I am creating a query with parent table 'Company', and child tables
'Director', 'Secretary', 'Capital' and 'Subscriber'. When I run the query I
can only see the first parent record, and I cannot find how to see the other
ones. When I add the 'Subscriber' table and run the query, I cannot see any
data at all, even though the link is correctly shown.

I am a novice at queries with a one to many relationship. Is it normal that
I can only view the first parent record? How could I set about finding what
is wrong with the 'Subscriber' table?

Thanks for any help.
Dudley
 
Make the links a left join. Open query in design view, click on the line
forming the link, double click, select the option to see all records from the
"Company' table and only those that match from the other table. Repeat for
all links.
 
Thanks for your help.
Dudley

KARL DEWEY said:
Make the links a left join. Open query in design view, click on the line
forming the link, double click, select the option to see all records from the
"Company' table and only those that match from the other table. Repeat for
all links.
Click to expand...
 
Back
Top