Get Valuelist items one by one

[dervaish]

hello

i need some help/assistance to retrieve values in a value list. i know i can use valuelistitems function to get all the values at once. but what i want to do is to get 1 item at a time [using a loop] n then add it to a filed in a table. then get the 2nd item and add it to another field in a 2nd table and so on. for now i have around 50 items in the list and want to get each item individually and then add it to approperiate field in a table. [all this through a loop to add items to corresponding fields in different tables]

thanx in advance for the help.

[David Jondreau]

Set Variable[$list; ValueListItems(Get(FileName); "ValueListName")

Set variable[$end; ValueCount($list)]

Loop

Set Variable[$counter; $counter +1]

New Record/Request

Set Field[ fieldName; GetValue($list;$counter)]

Exit Loop If[$counter = $end]

End Loop

[dervaish]

thanx so very much DJ. worked perfectly. much appreciated.