Hi guys,

can some one help me to solve this issue:

How to create a variable that stored many records? actual i have a foundset and i want to copy data of each records to a global field that will display the data of all fields.

for example:

record1= men

record2=ladies

record3=kids

and the data in the global field should display: "men ladies kids"

thanks.

This sounds like separate topics to me: 1) how to store more than one value in a variable 2) how to get data from multiple records into a global field.

1) There are a few methods to store more than one value in a variable, this is my favorite: http://sixfriedrice.com/wp/filemaker-dictionary-functions/

2) If you have a found set, and you want to get some data from each record into a global field, you would loop through the found set, and use the Set Field script step to keep adding data to your global field. If you need help with the loop, search FileMaker help file for "loop" - there is an example there.