forms 5 required field

[Quoted] I am working with Forms 5. My table is defined with field X which is numeric but is allowed to be null at the database level. In fact it has to be because the rows are inserted with a script, then queried in a form and then the null field X is updated. (inputting votes for a candidate running for election). I don't want field X to remain null when the form is saved and committed, however, but if i make the field attribute Required, when i "save", the form does not fail and tell me that the field is required which it would if the field was "not null" at the database level. I have tried to code various triggers but can't seem to get the right combination that will prevent the commit from happening.

Ideas?

email or post (pls use johnstd_at_region.halifax.ns.ca to email)

D. Johnston

-- 
Diane Johnston aka The Voice Of Reason
tvor_at_accesswave.ca      
http://www.accesswave.ca/~tvor