I have a db that has a validation of 'not empty' and also has strict and a message on it. But now I'd like to script making records into the db but also need the validation for when users manually enter info.

When I script a record to be made and try to enter the info into a field when the validation is on, it fails, but when I turn off the validation on the field then I can add any info I like. Can I get around this at all?

[color:blue]set myNewRecord to create record

go to myNewRecord

set cell "BookCode" of myNewRecord to "0027000605"

I guess the question is, why let a script enter incorrect data but not a person?

If you were using FMP 7 you could use the Commit Record script step with the option to bypas validation.

Well, the script won't enter incorrect info, but a user always can. It's a big system I have, so there are sufficient safeguards to automation, but when users are more direct then there are not.

Do you have a suggestion that will help me? Thanks! -)