Capture and store the Sort Order
FM Pro 10 & FM Pro 11, FM Server 11 on shared network. Solution built on FM Pro 10 ,Windows XP OS
Is it possible to Get(sort_order) or something similar? i.e. capture and store the sort order and wether it's ascending or descending.
I have many single field sort buttons as column headers as well as a sort button that opens the dialog for multi field sorts. It would be nice to display the current sort order on the list.
More importantly, it would be a great help if I could store an order and direction to come back to from future layouts. i.e. like a 'back arrow' sort of function.
Anyone had any ideas along these lines? I can do it fine from the single field buttons by setting a global text field value, but I can't figure out a way to store the direction. As for the multi field sort dialog, I have no idea.
Any help would be appreciated.