Hello

I have a situation where I have a database made for other people.

They have a value list which they have to change once a year. they will always have to do a find for the FIRST value of the value list.

Is there a way to automate this?

For example this year the first value of the value list is "greystone"

and next year the first value might be "rusty" but I would like to know if it is possible to do a find for the first value in a value list.

Thanks very much

Try a script along the lines of:

Enter Find Mode [ ]

Set Field [ yourField; LeftValues ( ValueListItems ( Get (FileName) ; "yourValueList" ) ; 1 ) ]

Perform Find [ ]

Since it is a radio button value list in the field . Is there a way to select or paste in the 1st radio button during find mode?

Manually, yes. If you want to automate this - that's exactly what my script does.