No script needed.
Go to Field options for each such field. Select the Auto-Enter tab. Enter "No" (without quotes" into the data box. Each new record will then start with a default value of "No".
Hi, I should of said that i can't use that option because i want to use this as a reset button at the end of each project. I want to create a button/script that sets all 10 radio buttons to "yes" or "No". Paul.
When you create a new record all of them are empty.
Had me thinking in terms of newly created records. You'll still need that method for new records.
Assuming that all of these are fields in the same record or fields with global storage, a script with a series of set field steps could set them all to "No".
You could also add an 11th field (ClearFlag, type number) and use this auto-enter calculation to set the fields all back to "no" by setting it to 1:
If ( ClearFlag ; "No" ; Self )
And then clear the "Do not replace existing values.." check box
after Putting 1 (or any number except zero ), you'd clear the field so that you can then click radio buttons to select "yes" where needed.