How to merge multiple records in single form?

[Marty]

Hi-

I have a query in a stored proceedure which returns 5
records.

I want to put the results of the 5 records into a single
form. All I get is the result from the 1st record.

How does the form know that the data are coming from the
1st, 2nd, 3rd, etc records.

For example, the MS Word 97 template says:

The following are the inventors:
1. {MERGEFIELD inc_name}
2. {MERGEFIELD inc_name}
3. {MERGEFIELD inc_name}
4. {MERGEFIELD inc_name}
5. {MERGEFIELD inc_name}

And I want to merge in the 5 names that I get in the 5
records. I put in the {MERGEFIELD inc_name}command in the
template 5 times, but it obviously prints the name from
the 1st record 5 times. How do I differentiate among the
names in the 5 records?

(In actuality, I allow for up to 14 inventors, and any
number of records up to 14 may be returned.)

Thanks for your help.

Marty

 

[Doug Robbins]

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 respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP