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! Go to Solution.
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:
I suggest just removing that entry (with the trashcan button)–I don’t think you’ll need anything there. But do enable these:
Wrap this expression in SORT() to sort dropdown menu entries:
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |