One-to-many recs in datasource tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 23 Mar 2007 18:25 GMT

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.

Reply to this Message

+Bob+ - 23 Mar 2007 20:11 GMT

>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
[quoted text clipped - 8 lines]
>
>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 ?

Reply to this Message

Dennis - 23 Mar 2007 20:26 GMT

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.

> >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
[quoted text clipped - 13 lines]
> physical tables, then use a catalog mail merge in Word to build the
> doc ?

Reply to this Message

+Bob+ - 24 Mar 2007 21:45 GMT

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

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?

Reply to this Message

Doug Robbins - Word MVP - 24 Mar 2007 00:05 GMT

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

Signature

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

>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
[quoted text clipped - 12 lines]
>
> Thanks in advance for any insight.

Reply to this Message