Query on a set of optional M2M relationships

D

David Wetmore

I have a parent table with 3 many-to-many subtables where data the 3
relationships are optional.

How can I make a query that will show an empty field when a given
relationship does not exist?

For example, rows like this:
Parent1 Data1 Data3
Parent2 Data2 Data3
 
K

KARL DEWEY

Use left joins. In query design view click on relating field of [parent
table] and drag to relating field of [many table]. Double click on the
connecting line and select "Include all records from [parent table] and only
those records from [many table] where the joined fields are equal."
Do the same for all of the [many table].
 

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

Create Excel Spreadsheet from Access with 1 to many relationship 2
How do I combine records 1
Update Set Values 3
A Report/Subreport problem 5
Access MS ACCESS -- Help with query code filtered by option groups and check boxes 0
Append from flat file to a new file. 1
query Join problem 1
Limit relationships for a field 2

Top