Sort Descending

[bjanele]

Hi all,

I have searched far and wide to no avail... can anyone confirm for me that there is no simple way to sort a value list descending instead of ascending numeric or alphabetical? It's a relational value list that just uses one relationship, and even if I sort the appropriate field descending in the relationship, the value list still appears ascending. We have sort options up to wazoo for everything else; am I just missing something here? Thanks in advance for any assistance!

[LaRetta]

Talk to us about the field - data type, purpose. What SHOULD the sort be based upon? And explain more about the table upon which it is based - does it have an auto-enter serial, timestamp?

And welcome to FM Forums! :wink2:

[comment]

can anyone confirm for me that there is no simple way to sort a value list descending instead of ascending numeric or alphabetical?

That is essentially correct. There is a limited workaround described here.

[bjanele]

Thanks to both of you. I don't think the workaround is going to work for this situation...

It's a pretty simple setup:

I have a Clients table and a Jobs table, and the relationship is based on job number, (sorted descending although it isn't helping). Then I have a relational value list for jobs so that depending on what client the user has selected from a different list, the jobs list will display a list of all jobs for that client. It works fine except that the list starts with the first job ever created for the client (Job number is a primary key), essentially sorting ASCENDING. However, our users are mostly going to be selecting among the most recent jobs for the client, so they want the list to start with the highest job number (descending instead of ascending)... It really seems like such a simple thing! :)

[mr_vodka]

You may have to use a small popup window instead. With the window, you could display the records in the order that you want and allow the users to select from that list. For large VL this method is preferred anyway.

[comment]

I agree with John - and if you follow the link from my link, you will find some nice examples of this method, courtesy of Fenton.