I have tried searching the forums here, but that function seems to be broken. Hasn't worked for a few weeks now. So if this is a redundant post...Sorry.
I am new to MySQL and have created a database with a MS Access front end. Everything works great, but I want to limit users from adding incomplete records. I thought the "Not Null" setting would not allow users to add records with Null values for the fields I specified, but they get added anyway. Does anyone know how to do this? I''ve got more experience with Access and wish the "Required" setting in Access existed in MySQL, but it doesn't.
Any ideas would be appreciated. Thanks in advance!