I would like to display on a layout the order in which the table is presently sorted. If the sort selection is changed, this field would reflect the new sort order. How can this be done ? I tried with a global field and the Get(sortstate) function but this only tells me if the table is sorted or not (0,1)- doesn't give me the field name.

I'm also looking for a method where a user could select the sort fields from a dropdown list (where I would put only a few fields-not all of them), and have the sort run after having done the selection.

Thanks for your help

Hi, Normand.

If you sort your foundset by script, you can do it having one global field, where you will put sort order.

But how do you get the present sort order. I could not find any Get function which seemed to return this information ?

Take a look at this video from Matt Petrowsky. It answers your questions.

http://www.filemakermagazine.com/index.php?catid=1

Scroll down to "Ultimate Portal Sorting."