Value List / Set functions?

[Laura Linton]

I've been checking out my FM reference books for various value list / set functions. I have a field in my database for level. This could be interpreted as grade for the people in my database but not necessarily. I want to write a utility that checks if the level is in my grade value list (is it a valid member of my set - problem 1), what is its position in my value list (grades are not necessarily numeric so I can't add 1 to them - problem 2) so I can change it to the next grade in the value list (problem 3 - easy with the GetValue function if I can take care of problems 1 & 2).

Any suggestions?

[John Mark Osborne]

I think this file on my web site will solve your second problem of identifying the position of a value in your value list.

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000049