AnsweredAssumed Answered

How to turn off auto sorting in FMP10?

Question asked by conchology on May 25, 2009
Latest reply on Feb 13, 2012 by meg_cuddihee

Title

How to turn off auto sorting in FMP10?

Post

Hi All,
Just upgraded to FMP 10. Got a small issue which I didn't anticipate. Filemaker is now auto sorting? The worst thing that could happen... is auto sorting for me.

As we are working on correcting sorted information; we correct fields that are sorted to find the mistakes, we correct 1 field to go to the next and check the correctness. Now this is not possible as we correct 1 field and the auto sort kicks in... 
 
Is it not possible to work anymore with partially sorted found set of records?
 
 
This is what happens: 
- 1 table database : 10 fields no relationship
- layout is in list view with no portals or anything.
- script is with a find to find a set of data and I sort it to field x and y
- the list view shows the results field y that needs to be corrected if needed.

If content of field Y is sorted it shows in rows as:
record 1: field Y: abc
record 2: field Y: bcd
record 3: field Y: cde
record 4: field Y: def

If field Y in record 2 is wrong - it needs to be changed manually to efg

in FMP 9 it would show as following:
record 1: field Y: abc
record 2: field Y: efg
record 3: field Y: cde
record 4: field Y: def

And you can just continue browsing to the next record

in FMP 10 it auto sorts the result to:
record 1: field Y: abc
record 3: field Y: cde
record 4: field Y: def
record 2: field Y: efg

Making it impossible to correct a found set of records sorted.


I've found a solutions to fix my problem - but it is with relookup fields which makes it quite impossible to work on 1000 of records a day, as it has to relookup a field z and w based on the values of field x and y - then sort on the field z and w and then you can change the values of x and y without having this autosort kicking in. It makes the process for nothing harder...


So, how can we turn this auto sorting thing off?

















Outcomes