Please help...

Is there an elegant way to gather field data from multiple records and get them into a single variable.

I want to move through multiple records for equipment that has been checked out by an individual and what I am trying to do is put the names from all of the equipment records into a email message field.

I am currently using 3 variables, 1 to grab the name from the record and the other 2 to bounce back and forth compiling the list.

Thanks for your help.

GetNthRecord function in a looped script is the most elegant way I know to "gather field data from multiple records". I have written a script that will gather all field data from one field in the curent found set, then return that data as a script result.

I'm not sure if it applies to your application, but perhaps by looking at it you could figure out what I'm talking about.

FieldList.txt

thank you for taking the time to do this. I will give it a look see.

Cheers.