sort choice in descending order (Z to A)

[Evan2]

Hi

I have a lookup select box type field for a catalog item. I want to show the data in descending order (z to a) to the users. I tried the reference qualifier javascript: 'ORDERBYDESCu_sub_access'  but its not working. PFB the screenshot and let me know how to achieve this.

Regards,

Evan

[Saurav11]

Please use below:-

ORDERBYDESCu_sub_access

Also make sure the sub access field is available on the form level of the reference table.

Please mark answer correct/helpful based on Impact.