When not using custom values, Filemaker insists on sorting the values in the manner you have encountered and with the limitations you describe. Even being able to sort on a hidden column would be an improvement. I've requested this on FMP's feature request form in the past. Perhaps others should do likewise as this is one area where competing products provide much nicer options for displaying table data in a value list.
seems sorting valuelists has been wanted since at least V6 (or whatever was before 7)... IMHO - it's doubtful they'll add it now.
We've been working on it here. In a MySQL table, we have the values, and a Sort_Value. With some custom functions, we've managed to sort the arrays any way we want. Now I'm trying to get them in a valuelist.
Problem - unstorable calculation holds the results of the custom function.
Read to have a lookup field (that can be indexed) look at that calc field, and base a valuelist off that lookup field. But it's not working so well right now.
Thanks for your reply. It's always good to know when to stop pounding my head against an immovable object! I tried the hidden column approach by returning the second field used for sort with a TextColor white added, but the color gets stripped off the text, which probably makes menu's more consistent, but limits us this way...
I'll add my voice to the FM feature request. What is up with Filemaker though? Some really simple feature requests get really ignored... for forever?