Yes, it would be very useful to have a choice between 'Sort Once' and 'Keep Sorted'.
I didn't understand your relookup idea. I believe I would populate a global variable with a list of ID's of the current found (and sorted) set, then use an "editing table" with only one field - an unstored calculation field =
GetValue ( $$IDs ; Get ( RecordNumber )
This would be related to the main table, matching the calculation field to the ID field in the main table.
I can think of a work-around. You'll have to decide if it's worth the bother.
Define a field of the same type as the field on which your layout is sorting.
Use Replace field contents to copy the data from your sort field to the new field.
Re-set the layout's sort order to sort on the new field.
Edit your data--since it's no longer sorting on the field being edited, the order will not change.
When finished, re-set the layout's sort order to sort on the original field.
That is what I'm doing - a relookup which takes the latest info from field_x to field_sort_x, the replace will work also, then I sort the field_sort_x and I can change the info in the field_x without the auto sort kicking in.
I did some testing and the relookup is just that bit faster for me.
I had to make several special scripts to make it work for my employees. But it is a real pain in the a*s, as this partial-sort is just the easiest thing to work with as no programming and extra fields are needed. Now I need to add double fields with field_sort to do a kind of relookups/replace to get the same work done as in FMP 9.
A real hassle, because now I cannot just sort a field anymore in the spur of the moment and work on that found set - Now I've to think about sorting the special field and then work on the other field...
Please Filemaker give us 'Partially Sorted' back!
I too would like partial sorting as an option.