I am having quite the problem with this little issue. I have a field in a table called flag. It is either a 0 or a 1. I want to use it to display or not display records ( like a delete). I am using the Check/Radio input. I can easily change the field in the database to a 1 by checking the box, but I am unable to change it back to 0 by unchecking. I always get:
Field ‘Void Transaction?’ can not be empty!
I am using a static join to map the fields. Is there a problem writing 0 back to the database (mySQL)?