Faster Field/Loop Update Method for a Found Set?

[smilemaker]

Hello. I'm working with Filemaker 11. I have a found set of about 1000 records. I need to replace the data in one field (date)-- with a different date. I have tried the replace field contents script step. I have tried a loop script with variables. They work. But, it is slow with this number of records. It is taking several minutes to do this. I'm hoping there is a faster way to accomplish this. Thank you for any help.

[bcooney]

There are ways to optimize a loop, and Replace is not multi-user friendly, so you're probably best not using it.

When you loop, be on a form view with no unstored calc fields and Freeze Window before you start the loop. You can open a new window (offscreen perhaps), and close at the end.

On another note, why are you replacing a date? Perhaps what you need is a child table with a new record?