Gathering multiple values

[sflynn]

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.

[dansmith65]

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

[sflynn]

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

Cheers.