Value lists - Sort values
I have a value lists that uses a value from a field and displays even a second field.
The first field is a number in a scale and the second field a text that explain the scale.
The problem is that when you choose to display only the second field, FM sorts the list based only on the second field and only in alphabetical order. So the list is totally disarranged as regards my scale.
Is there any alternative solution to have a value list sorted by the first field, but without displaying it?