Sort Order of Value List

[bcooney]

I have a value list of competitions, hiding the ID.

RegionA 2010

RegionA 2011

RegionB 2010

RegionB 2011

and so on, for many years. I've created a value list for a popup menu that lists the competitions alphabetically.

Is there a way to list the competitions by year descending (year is a separate field from name) without changing waht is displayed in the value listing? I'd like the value list to appear as:

RegionA 2011

RegionB 2011

RegionA 2010

RegionB 2010

tia,

Barbara

[Ron Cates]

There is no easy way to change the sort order of a value list.

Perhaps you can add a global field to select the year first then setup a conditional value list based on the year selected. Just a thought :)

[bcooney]

I didn't think so, but gave it a shot that someone might point out a checkbox I missed or a technique I'm not familiar with. Breaking it down to select Year, select competition might just be the way to go, but right now I'm trying to stay with the one popup.

[Aussie John]

I didn't think so, but gave it a shot that someone might point out a checkbox I missed or a technique I'm not familiar with. Breaking it down to select Year, select competition might just be the way to go, but right now I'm trying to stay with the one popup.

I'm probably missing something but the valuelist by field gives the option to sort by the second field.

[comment]

A value list based on a field is always sorted alphabetically, ascending - using either one of the two fields. Since you are already using the second field, your options are limited. I think the best you can do here is:

2010 RegionA

2010 RegionB

2011 RegionA

2011 RegionB

Of course, there are alternatives to using a value list - as you well know.