Merging Data From Access 2000?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris LeFebvre - 30 Apr 2004 14:57 GMT

I'm working on a form letter in Word 2000 that merges data from an
Access 2000 database and if I had a week or so to work on this I could
probably figure this out but I've got to get this done by tommorow so
any help would be appreciated.

The Access database has a main table (RegInfo) that's related to three
other tables (A, B & C) in a one to many relationship through the ID
field. So far I've got the main document setup and opened the database
main table as the data source and inserted fields for Name, Address etc.
and now I'm moving on to the parts where I need data from the child
tables. I've figured out from reading some of the few posts about this
that I need to use the insert database function but in the query options
where I specify what records are being selected how do I refer to the ID
number field from the documents datasource?

Thanks,

- Chris LeFebvre

Reply to this Message

Doug Robbins - Word MVP - 01 May 2004 03:48 GMT

I gather that what you are needing to set up is a one to many arrangemnet.
Quite frankly, I would do the whole thing in Access

But, see the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I'm working on a form letter in Word 2000 that merges data from an
> Access 2000 database and if I had a week or so to work on this I could
[quoted text clipped - 14 lines]
>
> - Chris LeFebvre

Reply to this Message