Frank, I think using a field to store the sort order will get you where you want. Add the 'SortOrder' field to the table sort as the first sort item, followed by whatever other fields you would normally want to sort by. Then, if you were to set the sort order on all the records to the same value, it effectively removes that (the 'SortOrder' field) as part of the sort criteria.
Example: Set the sort order of the table to be: SortOrder, Name, Status (in that order) Set all the SortOrder values to 0. Then the table essentially sorts by Name, then Status. Once you adjust your table sort orders, just refresh the table. (you said using a display only column - I think you 'd need to add it as a regular field to the underlying table) Does that help? Thad Esser Remedy Developer "Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky?" - Pink Floyd |------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Frank Caruso <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |[email protected] | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |07/02/2009 06:58 AM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Pragmatically Sorting A Table Field | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Sent by: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Action Request System discussion list(ARSList)" <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| ** ARS 7.1p5 SQL Server 2005 Fairly sure this is not possible but .... Is it possible to control the sort order of a table through code? I know you can set a default sort, and that the user can click a column, but can work flow be created to change the sort order order of a table? I want to set values in a display only column and then sort on that column. I can set the column values, and the user can then manually click the column to sort it, but that is not an optimal solution. Thank you Frank _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
