No there's no good workaround, it's an INCREDIBLY STUPID "feature" we need to be able to control it (and I hope FM Inc in the future will show it's devs more respect when introducing new feature that completly change the behaviour of our hardly coded solutions !)
A simple work around was shared here by UlearnIT, in the forum back when FileMaker 10 was the latest release. (We were "blessed" with this new feature when 10 was released.)
It's definitely a kludge, but it works.
Use a script with this line it:
As long as the script is paused, you can edit your records but they will not auto-sort until you continue the script. ULearnIT suggested adding an "Edit mode" button to the layout to run this script and lock down the order in this fashion.
Thank you PhilModjunk, ... for the quick fix. It worked with the first script I wrote, and with a little time spent writing this, fix-sort-script, for each field I need sorted, I will be able to use the FM 11. I assume FillMaker will not be offering a "deselect auto sort feature" any time soon or they would have offered it by now???? I can imagine many situations in which using this auto sort is a real pain... I have really liked this program for its versatility, starting with the FM 3, but as the compurter wear or so do a perfictly fine programs.
Again Thank you,
I would love to see the option to disable the auto-sort. A number of us have used the Feature Suggestion Form to ask for this, but as a fellow user have no more access than you to whether or not FileMaker will change this or not in a future release.