I'm sure this has been answered, perhaps I'm not searching for the right keywords. Anyway, wondering if someone can assist.
I added a new text field to an existing database. The default value is "No." But, when a record is approved, the user changes this value to "Yes." This condition applies for all new records. Now here's my problem, I need a simple script that would update the other 500+ records currently in the database to reflect "Yes" in this new field. Note the field is blank for these records. System info: OSX 10.2.8 Server, FMP6.