mail merge with one to many relationship

[yoshe]

Is there an easy way (ie, not too much coding) to do a mail merge from a database with a one-to-many relationship? We have a Word form letter that, for each record, we want to list at the bottom the linked child records. It seems we have to array all the child records into a single record in order to do it from Word - isn't there a simpler way to do it? Thanks for any help.

 

[AllanBertelsen]

Hi yoshe

The trick has to be done in word. In word you can use the NEXTIF field to fill the list in your letter.
I access you make a normal query including the to joined tables. Feilds from the "mother" tabel will be repeated for all its related fiels from the other table.

In the merge document you use nextif to run thru all the related record.

http://office.microsoft.com/en-us/word/HP100779671033.aspx

Hope you can use it.