I've got a field that requires 2 numeric characters and 1 alpha character to be valid. I've set up the following validation:

Length ( Precinct # ) = 3
and
Exact ( Left ( Precinct # ; 2 ) ; Filter ( Precinct # ; "0123456789" ) )
and
Right ( Precinct # ; 1 ) = Filter ( Upper ( Precinct # ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" )

But, validation doesn't take effect until the record is committed. I'd prefer to have a script trigger that would kick in as soon as the field is left. Several attempts to write such a script have failed. Any suggestions?



--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/