Finding the next value in a value list...

[Saubs]

I'm trying to write a script that will perform a find on the next entry in a value list. For example, if my layout has a field on it called "Name", and that field uses a value list called "Names", and the Name in the current record is "Joe", I want to launch a script that will perform a find on the value immediately following "Joe" in the value list. Hope that makes sense.

Sure, the user could just go into find mode and arrow down 1x in the value list that pops up, but--long story short--I need it to be done via a script.

Thanks for your suggestions--

FileMaker Version: 6

Platform: Mac OS X Panther

[Ugo DI LUCA]

Try this :

Middle(VL,Position(VL,"