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

    Unanswered: Updating all records

    Greetings

    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!
    -steve

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can make a script that select this records
    Make a loop and use define field to change the field
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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