hi,

I'd like to find out if it is possible to automatically select the next value in a value list through a looping script, in a similar way to the go to record (first/next - exit at last) options.

I'd like to use this for my room bookings database. I have relationships set up to show if a particular room is unavailable at a certain date/time period and I would like a script to loop through the list of rooms, and copy the names of rooms that are available into a global.

Thanks,

PJ

If you filter the relationship to show just the rooms that aren't booked for the specified day, you can allow the user to select from a value list based on that relationship. If you still need it, use the ValueListItems() functions to see the value list items in a field. This can be put in an unstored calc, no loop is necessary.

You might be interested in this sample from a previous thread:

http://www.fmforums.com/threads/download.php?Number=128841