# Open Office 3.1 Base question
**URL:** https://boards.straightdope.com/t/open-office-3-1-base-question/519771
**Category:** Factual Questions
**Created:** [December 2, 2009, 10:47pm UTC](https://boards.straightdope.com/t/open-office-3-1-base-question/519771 "2009-12-02T22:47:13Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Carol\_the\_Impaler](https://boards.straightdope.com/u/Carol_the_Impaler)
#### Post date: [December 2, 2009, 10:47pm UTC](https://boards.straightdope.com/t/open-office-3-1-base-question/519771/1 "2009-12-02T22:47:13Z")
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.
---
### Author:  [@Imasquare](https://boards.straightdope.com/u/Imasquare)
#### Post date: [December 3, 2009, 1:47am UTC](https://boards.straightdope.com/t/open-office-3-1-base-question/519771/2 "2009-12-03T01:47:24Z")
Are all of the required to be completed fields represented on the form? Maybe the wizard left one of them off.
---
### Author:  [@Carol\_the\_Impaler](https://boards.straightdope.com/u/Carol_the_Impaler)
#### Post date: [December 3, 2009, 1:57am UTC](https://boards.straightdope.com/t/open-office-3-1-base-question/519771/3 "2009-12-03T01:57:31Z")
I did leave off the key.
---
### Author:  [@Carol\_the\_Impaler](https://boards.straightdope.com/u/Carol_the_Impaler)
#### Post date: [December 3, 2009, 7:57pm UTC](https://boards.straightdope.com/t/open-office-3-1-base-question/519771/4 "2009-12-03T19:57:42Z")
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.