I have various fields I use for value lists... e.g. if period=daily, set
value list days to variables:days

these are not sorted and display correctly as Mon-Tues-Wed, etc.

but when this field is used as a value list, they are sorted alpha.

any ideas?

--
-------------------------------------------------
Captain Guy
100ton-Sail-Towing-Coastal
Deliveries & Instruction-Power & Sail
New Smyrna Beach FL USA
386-689-5088
-------------------------------------------------
s/v Island Time (Beneteau 352#277)
AICW 845.5

In article <go-dnY9CvYKdKSnRnZ2dnUVZ_oudnZ2d (AT) earthlink (DOT) com>, "Guy"
<guy (AT) guym (DOT) com> wrote:

You don't say what version of FileMaker and I'm not certain about newer
versions, but the older versions I've got only sort Value Lists from
Fields "alphabetically".

You could change the data values to be:
"1. Monday"
"2. Tuesday"
"3. Wednesday"
etc.

then they will sort in the correct day order rather than alphabetically.
You may need an extra Calculation Field to extract just the name of the
day.

You can achieve the same result by using the Value List option to display
data from a second Field, and sort by that.

Helpful Harry )