Any way to NOT retain sort in FM 10?
I frequently do a sort on a field that is initially empty. The records with empty values are, of course, put first. I need to review those first few records and, in some cases (but not all), assign a value to that empty field (this is a subjective process and cannot be automated). Because of the retention of sort order (which, in most cases, is wonderful), I am then jumped to other records with that same value I just assigned. Instead of being able to just go to the next record (which, in previous versions, would be the next unassigned record), I have to get back to where I was in order to get to the next record needing assignment (I wouldn't always want to go back to the first record in the found set). Is there any way to opt OUT of sort retention on certain layouts, or any way to capture what record number I was on before the automatic resort so I can write a script triggered by the editing of that field? Any info or ideas are greatly appreciated!