turn value list sorting off?

[ddave]

I have a value list that comes from a field that calculates what months to show based on what year was selected. i.e. for year 2002, show fiscal months July - December

"July" & "

[Vaughan]

Errr, AFAIK no.

The best you can do is either create a Custom value list and type the values manually; or use the month numbers instead of names, and define the value list to display the month names as a second field.

I'd go for the custom value lists: I cannot see why they wouldn't be appropriate here (unless there is a chance that not all values are entered into the database).

[ddave]

Thanks Vaughan. I think I'll have to go with the month number idea. I want the value list for month to be dynamic based on which year is chosen so I don't think entering month values manually in the define value lists will work here. Thanks for your ideas!