Thank you Bruce.
Yes, filling my own sort field is both a workaround and a pain.
Doing this same job last week, Excel somehow got it's columns
disconnected during an auto sort, and I didn't notice. We sent a
mailing and every address had a randomized name on the label. Well,
that's my fault for using a spreadsheet to do a database job. Such a
mistake is not possible in FileMaker; randomizing cell values that is.
But this record jumping makes that work painful.
It appears that having a script paused is the most pain-free workaround.
thanks,
Geoff
On Nov 21, 2009, at 1:29 AM, Bruce Herbach wrote:
Geoff,
I don't know how to turn it off, but have a suggestion for a work
around. It may be more of a pain then a help, but here it is. Add
a number field to the table. Sort the list by the current
address. Then use replace field contents with serial number for the
new number field. Sort by the number field and then do all of your
corrections. Since the sort is now based on the number field
nothing should move.
When you are done set the sort back to normal. You can leave the
number field for the next time you have to do this or remove the
field.
I hope this is helpful. Bruce Herbach
Geoff Graham wrote:
Hi All,
Is there a way to turn off the new "Re-Sort at All Costs" feature
we now have in FM10?
I'm cleaning a list of addresses for a mailing list, and have them
sorted by Address LIne 1. Thus all the numbers (the vast majority
of "good" addresses) go to the top, I scroll to the bottom to fix
the records that have say, "Curlew Center" as the street address.
Of course, the moment I enter the numbered street address, the
record jumps position thousands of records away from where it was,
and way, way off my screen. Heaven forbid if I click out before I'm
finished editing the record. Yes it's still the current record, so
I can Control-Down and Up arrow to reveal the record but...
In some situations this feature is very cool; in this one it
stinks. Can anybody tell me where I can uncheck this feature?
Geoff
