Finding Any Empty Field
I've been looking for an answer to this question but can't really find a definitive one. No field in my database can be left blank, I have 2 tables but quite a lot of fields in each table. Ideally I want a script to search every field in the database for an empty value, if it finds any, a custom dialogue box appears and directs the user to the blank field.
Is there an easier way than than writing a long if statement containing every field in my database?