Activate Script upon field entry

[stasker]

My goal is to activate a script when I check a checkbox. How can I do this?

Also, I have a value list that is built from values of a field in another file. Is there anyway to omit certain values from the list without deleting the record in the related file?

Thanks!

[goldraven]

You can attach scripts to fields just as you can to buttons. Create the script you wish and attach it to the checkbox so that when they click on the checkbox, it activates the script.

As for your second question. Here's one way you could do it. Create a binary field in the file that your value list generates from. Set those you want in the value list to "1" and those you don't to "0". Create a Calculated field that is blank if the binary field is "0" and equal to the value list field if "1". Now base the value list on the Calculated field instead.