Restrict data entry in numeric field to be less than a certain value

This should be easy with Data Validation.

Go to the Advanced Properties  of the Table  and enable Data Validation.  It's bullet proof as it limits data entry errors regardless of if the data entry is by form or grid edit or import or API

Make a formula which calculates to the error message words or blank.  Blank means no error, but if there are words, then the save will fail and the words will display.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------