Sort problem

[ausbob]

This is a bit difficult to explain, so much so I'm not sure if I have posted it in the correct section. But here goes.

Whenever I click on the screen to deactivate a record (click outside a field). The program automatically does a sort of 3 to 5 records. This seems to be indiscriminate of the number of found records and it happens every time I click out of a field. I am wondering if this has something to do with how I have stored the fields but I would appreciate any help. I Hope this makes some sort of sense.

[Vaughan]

FMP 10 introduced a feature where records are re-sorted if the sort field value changes. Is this what you're seeing?

[ausbob]

I think so. I am a bit of a novice at this but I remember trying to limit my sort scripts as I new they took up time. By sort field what do you actually mean.( sorry for what I think is a very basic question)

[ausbob]

I just tried something again. If I click in a field (any field) then click out nothing happens. If I click in a field (any field) and change the data and click out the sort occurs.

[mfrapp]

if your sort field has the auto-enter modification attribute, i guess it would trigger a resort every time you change any field