Hi everyone here is my problem. I need to work with the current database that we are using now but need some help.
The database is made up with Member companies and employees of those companies.
MemberID - PK
Employee ID - PK
MemberID - FK
In the beginning we really didn't think that we would need too much info on the employees but things have changed.
What I want to be able to do is create a query that would give us all the main contact mailing info as well as those employees that would like to receive the mailing. So when I run labels I run it off one query.
Example Company ABC has John Doe as main contact but we would have Jane Doe, Mike Doe, and Dave Doe as employees in the employees form. John Doe, the main contact, informs us that Jane Doe needs to be included in all mailings to the company. This is where I'm having trouble. I can add her to the mailing but I have to create two queries and run labels twice. How can I include her (employee) and the main contact without creating multiple queries and without making major changes to the database?