Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:
See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at
http://homepage.swissonline.ch/cindy...faq1.htm#DBPic
Or take a look at the following Knowledge Base Article
http://support.microsoft.com/default...b;en-us;211303
http://cornell.veplan.net/article.aspx?&a=3815
However, If I were you, I would use an Access report. It's far simpler.
..
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"jws" wrote in message
news
I have related data in two seperate but releated Access tables but it
appears
that I can only slect one source. If I query the two sources I get the
data
from the one table repeating for each line of the other table. These
tables
have a one to many relationship and I want header data from one table and
multiple rose from the other on the merged page.