Good day everyone. A quick question:
I have a value list that shows records from a related table which includes 2 fields: A job number and a job description.
I want to sort the drop-down list by the job number, but in reverse order so that the most recent jobs are on top. The dialog box allows one to sort by either the first field or the second field but not in reverse order. The only seemingly available option is to use the "Custom Values" option, but, as you can imagine, this would require me to create a carriage returned list of thousands of numbers covering me will into the future (and seems very clumsy).
So, is there a simple way to sort a value list in reverse order?
Many thanks in advance.