Create a Form (with Subforms) Based on A Query/Queries

  • Thread starter Thread starter Lexy
  • Start date Start date
L

Lexy

Hi Guys

The Database I've recently built has a Main Input form.

This form shows the:-

a) Company (table 1)
The Contacts within the Company (table 2, linked as one-to-many with Company
table)
b) The Contact Log per Contact within the Company (table 3, linked as
one-to-many with Contacts)
c) The Mailshot activity per Contact (table 4, linked as one-ot-many with
Contacts)

Obviously I've used subforms within the main Company form to show the
Contacts, Contact Logs and Mailshot info on the one form.

All the above works fine.

I now need to be able to run a query that displays only certain records from
the database via this form.

I understand that I can set the source of a form to be a query, but as there
are all the above one-to-many links (& resultant subforms), am not sure how
to go about doing this.

I'm guessing that I need to set up individual queries to represent each
table, but don't know how to link the queries or how to then link the queries
to the form.

Can you help at all please?

Thank you once again.

Lexy
 
One query - left join the one table to the many table(s). In query design
view double click on the connecting line and select option to see all records
from the one side and only those that match from the many table.
 
Back
Top