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