Word text field merge

[PSLondon]

I would like to use a word document for remote data collection using text fields. I can get the text fields to appear on each merged page but what I would like to do is merge the primary key of one table to a text field so when i collect the data I have a link to other tables. So far I get the reference data and text fields to merge okay but I only get the first record from the key field to merge into every text field after the merge. Is there a way to get the key field to merge to each page or is there another way to get the key field onto each page and then be ablke to read it afterwards in relation to the text fields

 

[tlbroadbent]

This swwms to be an appropriate question for the MS Office forum68 rather than SQL Server unless I'm misunderstanding your question. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm