One-to-many recs in datasource tables

[Dennis]

I have a main Access (2002) table that's used for the datasource for a Word
(2002) document. I have a secondary table that's populated with the various
document version information. I need to dynamically build a Word table, and
populate that table with the information from the secondary database table.

If I have only one line of detail data, I'd build only one line of table,
but if I had 10 lines of detail data, I'd need to build 10 lines of table.

So - how do I use a secondary table in a Mail-merge, and how do I populate a
table dynamically?

Thanks in advance for any insight.

 

[+Bob+]

I have a main Access (2002) table that's used for the datasource for a Word
(2002) document. I have a secondary table that's populated with the various
document version information. I need to dynamically build a Word table, and
populate that table with the information from the secondary database table.

If I have only one line of detail data, I'd build only one line of table,
but if I had 10 lines of detail data, I'd need to build 10 lines of table.

So - how do I use a secondary table in a Mail-merge, and how do I populate a
table dynamically?

Thanks in advance for any insight.

I'm not sure if I understand exactly what you want to do, but how
about using a query in Access to build the merged data from the two
physical tables, then use a catalog mail merge in Word to build the
doc ?

 

[Dennis]

The problem is that I could have 10 version records for a single document. If
I use a query, I don't want to have extra rows. I just want my set of
versions and my set of other values for each document.

 

[Doug Robbins - Word MVP]

More easily done with a report in Access.

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/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at

http://cornell.veplan.net/article.aspx?&a=3815


--
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

 

[+Bob+]

The problem is that I could have 10 version records for a single document. If
I use a query, I don't want to have extra rows. I just want my set of
versions and my set of other values for each document.

"+Bob+" wrote:

A couple questions for you: If this is essentially just a "report",
are there particular reasons you don't want to use Access directly ?
Also, can you set aside a fixed amount of space per page in Word (one
document summary per page) or do you really need it to vary
dynamically on the paper acreage use per document?