Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Updating all records


    Greetings All

    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.

    Thanks in advance!

  2. #2
    Join Date
    Jan 2003
    Paris, France
    You can make a script that select this records
    Make a loop and use define field to change the field
    Olivier Miossec

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts