Value lists always sort ascending alpha-numerically. Why shy from creating records? If you use repetitions then you will be limited. And what if they wish to then include a second field with that value list? You will have to change your process anyway.
A list layout is just as easy to use (or even a portal). Your idea is nice but repetitions aren't the best choice here. :^)
Thanks for that, The reason I want to use repetitions is to limit the number of options. It is to be mainly used in Radio button sets and if there are too many they will not be viewable in the layouts
If you have room for up to 5 radio button values, manage your values on a layouat with a portal that has 5 portal rows and no scroll bar.
It is possible, for small numbers of values in a value list to specify a sort order if you use some slight of hand.
Say you add a number field with small numeric values (say 100 or less) where you specify the order you want for your values. Let's call this field "sortkey". Then a second calculation field: cSortOrder can be defined as this:
Substitute ( 10^SortKey - 1 ; "9" ; " " )
Select Text as the return type.
Then, in your value list setup, specify cSortOrder can be specified as the "also display values from second field". And then you specify that the values be sorted by this second field filled with invisible space characters.
Thanks for that option Phil, I will try it as soon as I have a bit of head space (got a few bigger things to deal with first).
Then I will report back
I forgot to mention that using repetitions to create value lists was a tip I got off Andy and Lee from Filemaker Success tips pod cast