4 Table query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to be able to build a query with data from 4 tables (I think). I have
5 tables:

tblMailing lists
tblMailing list junction
tblContacts
tblTrainers
tblAdvisers

Contacts, Trainers and Advisers can all be related to a Mailing list. The
Mailing list junction is used to associate one of these people to a specific
mailing list (so a Contact, Trainer or Advisers can belong to many mailing
lists.....and a Mailing list might have many people attached to it).

I want to build a parameter query that prompts me to choose a mailing list
and then produces a list of contacts, trainers or advisors who are attached
to that mailing list (also with email addresses that are stored in the
repsective table).

In the query i have added:

tblMailing list junction
tblContacts
tblTrainers
tblAdvisers

and brought down the key fields from each (e.g. Trainer Name, Contact Name
etc plus email address fields from each table)

The problem is, the query only produces a list if a mailing list has a
related record in the other 3 tables. Other wise it extracts zero records.

what am i doing wrong?
 
Use outer joins.

In the upper pane of the query design window, double-click the line joining
the tables. Access pops up a dialog with 3 choices. Choose the one that
gives you all records from the junction table.
 
Back
Top