Query with one to many relationship

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
 
K

KARL DEWEY

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.
 
D

Dudley

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...
 

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

Creating a query with one to many all on one line 3
Problem with query output 1
Query with 3 tables with 1 to many relationship 7
Select Query for a Parent-Child Relationship setup 1
unmatched record query question 2
Relationship Query question 3
Query showing all records from child table 5
multiple one to many 2

Top