I currently have a record insertion form which connects to my MySQL database on a remote server.
The fields and columns are viewable in this insertion form. I have selected them to display mostly as text fields and also as menu items. So far so good.
During testing, I have noticed that if some of the fields in the form are left blank when the form is submitted - I am rediredted to a blank white page with the message Column '(column name)' cannot be null.
I wish to allow some columns to be blank. Is there a way to do this?