Help with a Header/Detail relationship merge

[Keith-Earl]

Hello,

I am running Word 2002 SP3. I currently print our monthly invoices from a
"flat file" (unnormalized table) in MS Access. It works great: one invoice
per record.

Now I want to show line items on my invoice. I think I must somehow add a
sub-document on my existing form to house the new line items. In that
sub-document I will have to tell the query (or Word) to only select the line
items for that particular invoice. How do I do that?

I will gladly by a book or upgrade to Word 2003 if that help.

Many Thanks,

Keith

 

[Cindy M -WordMVP-]

Hi Keith-Earl,

You'll find a short discussion on three possible approaches, with links to
instructions and sample files in the mail merge FAQ on my website. Try the
DATABASE field one, first, I think...

I am running Word 2002 SP3. I currently print our monthly invoices from a
"flat file" (unnormalized table) in MS Access. It works great: one invoice
per record.

Now I want to show line items on my invoice. I think I must somehow add a
sub-document on my existing form to house the new line items. In that
sub-document I will have to tell the query (or Word) to only select the line
items for that particular invoice. How do I do that?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Keith-Earl]

Thank you, Cindy. I did find this page:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

But cannot find the articles you are referring to. Please direct me to
those articles.

Thanks,

Keith

 

[Cindy M -WordMVP-]

Hi Keith-Earl,

http://homepage.swissonline.ch/cindymeister/MergFram.htm

But cannot find the articles you are referring to. Please direct me to
those articles.

"Multiple items per condition" in the Special Merges section.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail