Mail Merge w/ data from 2 tables

[sedain121]

Im trying to automate letters sent to different clients with certain job information on it.

I created two tables one for client info and one for job info

so the data is seperate, i can search through the job info table for jobs and the client list table for clients

I created a query to merge the data so i could import it in microsoft word 2007.


It works fine but the problem is the query is now making duplicates in my client table for all my clients, one for each job #(meaning the client info is repeated for as many different job #'s i have)

why is the query adding the merged data back to the table? i thought query's were just used to filter data into a mergeable format(i tried to mail merge the two tables but it told me to make a query)

Is there a better way to do what im trying to do. I want to mail merge two sets of data(the client info table and the job info table(but only one entry from that table)) onto the same page in word.

[jzwp11]

What kind of query are you using? Can you post the SQL text?

Generally if records in the query results are duplicated it is a problem with the join between the tables. I assume that your tables look something like this

tblClient
-pkClientID primary key, autonumber
-txtClientName

tblJobs
-pkJobID primary key, autonumber
-fkClientID foreign key to tblClients
-jobdescription

[sedain121]

Figured out why I have duplicates thanks.

[jzwp11]

Glad you got it worked out!