Numbered value lists

[rflagle]

I have several numbered lists of information that are value lists in my database. When the popup lists are displayed in any given field, they by default are alphabetized resulting in out-of-sequence numbering:

1. Item 1

10. Item 10

11. Item 11

12. Item 12

2. Item 2

3. Item 3

4. Item 4

5. Item 5

6. Item 6

7. Item 7

8. Item 8

9. Item 9

Is there a way to have my numbered lists displayed without being alphabetized, so they are in the proper numerical order?

[RalphL]

You can use another field and sort on it. Value lists are made from the index and are always sorted. They are also text and the text sort is what you see. If you used text instead of numbers you could use 01, 02, 03, 04, ... 10, 11, 12.

[rflagle]

Thanks Ralph - That will work. I appreciate your assistance.