Help with Sorting values in drop down list

I have a table: Type which has a key field Type_NO and a table field TYPE.

I use it in my Requests table as a REF field.

I cannot get it to sort in alphabetical order in the Requests form. I’m using an ENUMLIST field.

I have tried everything I can think of but can’t get it to work.

WHAT am I doing wrong? Thank you.

Solved Solved
0 5 1,248
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

What does that mean?

Can’t get what to sort?

For what?

Enum and EnumList values are raw values, not expressions. You can’t use an expression here:

2X_0_00fa927fd2393ee5838568eac4d164ff5bc1583e.png

I suggest just removing that entry (with the trashcan button)–I don’t think you’ll need anything there. But do enable these:

2X_a_a4f78f8e7872d995cd23e64e6a723ac4ec384f25.png

Wrap this expression in SORT() to sort dropdown menu entries:

2X_4_455dcef49634afbeed4066cc684cd8e3b2bdecd7.png

View solution in original post

5 REPLIES 5
Top Labels in this Space