Thanks, that's a good tip - it becomes fairly obvious that you're adding spaces after six or seven values, so I'm a bit reluctant to implement it in a solution and then walk away. And the other thing I worry about is that I would then have "Friday " in my database, and I wonder what that might break in the future...
It would be perfect if we could convince Filemaker to allow sorting by a non-displayed field. Until then, it looks as if it's 01 Monday for me :-(
No, the SECOND field in the value list is calculated and contains the spaces. (thus sorts by the number of spaces!) the FIRST field is in selection (you can see the second field, but being spaces appears invisible). The SELECTED value is only chosen from the first field AND is the only value actually entered into to field on the layout.
Change the value list to use the number (serial/sort) instead of the spaces and you will SEE the numbers in the drop down list, but ONLY the first value-field will be selected and entered into the field.
-- sent from my iPhone4 --