Mail Merge from AC2007 DB with many-to-many relationship. The DB is split front-end, back-end on a shared file server.
My database contains the following 3 tables:
tblContacts(individual people with contact info)
tblFacilities(individual companies with contact info and corporate data)
tblFacilityContacts(association table necessary because tblContacts and tblFacilities have a many-to-many relationship.
I need to generate unique form letters(via email attachments) which can be addressed to the various facilities. Each letter would include the basic corporate data for the individual facility, as well as the multiple contacts related to that facility.
The tables work great when I set up master/child relationships in forms. But, I'm not sure how to repeat such relationships in a query so that i can generate comparable form letters. Am I screwed?