Merging Data From Access 2000?

[Chris LeFebvre]

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

 

[Doug Robbins - Word MVP]

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

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