Open Office 3.1 Base question

Factual Questions
1

I am new to databases in general and to Open Office in particular. I’ve created a form, but when I go to save a record I get the error message “Attempt to Insert Null Into a Non-Null Column”.

Background: I took an Excel spreadsheet, saved it as CSV. Then opened it in Oo Calc. Then copied into a Base table.

I set up the table using the wizard and only set to Yes those fields which are actually required to be completed.

Created the form using the form wizard.

Thoughts? Thank you in advance for the learnin’.

BTW - I have checked the Oo forums but am not finding the answer.

2

Are all of the required to be completed fields represented on the form? Maybe the wizard left one of them off.

3

I did leave off the key.

4

Coming back in to say that I’ve made sure all my fields are included on my form and that seemed to fix the problem. I also made no changes to the defaults when setting up my table.