How to sort a value list?????

[Mark Bowen]

Hi there,

I was just wondering how to do this best.

I have a pop up menu that uses a value list based on a field from another file.

When the values come up they are in alphabetical order.

How do I get them to come up in an order defined by myself.

I tried numbers in front of the items but it just came out as

1 - First Item

10 - Tenth Item

2 - Second Item

And so on...

Any help would be greatly appreciated.

Regards,

Mark Bowen

[email protected]

http://www.kingfishergraphics.com/phpBB/

[ldebondt]

If you use numbers to sort items you have to use leading zeros. This way a sort would produce -- 01, 02, 03, 04, etc... Depending on the number of items to sort you may want to use two leading zeros.

[ldebondt]

In a thread from another forum Russ Baker and CobaltSky discuss how to use leading zeros. Go here... http://www.maclane.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=20;t=000196

[Vaughan]

... unless the value list is based on the first field, and also displaying the second field. In this case, just ensure the first field is a number field, and sort the list by the first field.