Scripting a sort function

[jimkent]

Is it easy to create a script that recreates the sort funtion like Excel or just about any windows program's column. You know, when you click on the title of the column and it sorts by that column. I have a list of a few items that I would like to allow the user to click on the column (specify button) and run a script that does this. Any thoughts?

[andygaunt]

In FMPro 5.x or higher you can use the table view.

If you go into layout mode and then to the layout > layout setup menu you can click on the views tab and in the table view option click the properties. Check the sort data when selecting column.

Otherwise you have to -

1. do a manual sort for each field in the list,

2. script each option.

3. Assign each script to a button on the layout

plus if you want to sort ascending or descending on one button you have to sort each way for each field and script to select the reverse of what the last sort was.

HTH

[jimkent]

Thanks Andy, I think I'd rather do the latter bucause it looks cleaner to the end user (filemaker developer). Why is it though, that when I do the sort, in the script without a dialog, the last sort is perfomed and not the sort I set up for each column? Is this a function of the dialog that says "keep" or "replace" after I exit scriptmaker? I guess I don't quite understand that dialog.

[jimkent]

Wait Wait Wait... I got it. I opened up the user manual (pg 10-4) and read through it a bit along with your help. Thanks...