>>>Hi,
>>>Is it possible to generate mail merge document that contains master and child table such as invoice and invoice details?
>>>
>>
>>Word doesn't support a parent-child set-up, so you need to generate a flat cursor as the data source for the merge.
>>
>>Tamar
>
>Hi Tamar,
>
>I'm using your great Automation book to help me out here.
>
>Once I have my flat cursor built, how do i tell Word to start a new document, i.e., I have a header source something like:
>
>Employer_name, Employer_address, detail
>
>and data source:
>
>Employer1Name, Employer1Address, detail1
>Employer1Name, Employer1Address, detail2
>Employer1Name, Employer1Address, detail3
> etc.
>Employer2Name, Employer12Address, detail1
>Employer2Name, Employer12Address, detail2
>Employer2Name, Employer12Address, detail3
> etc.
>
>Where all the details for employer1 should be in one document, all details for employer 2 in the second document, etc.
>
>Thanks...J

I'm using Microsoft Word 2000, but, of course, need this to work in various versions.

I'm trying to make sense of Word "Next Record If" field, and added a First_Employer_Record field that contains a "Y" if it's the first record for the employer, otherwise, it contains a "N".

But I am still getting one detail record per page.

J