On Wednesday March 15 2006 03:00 am, stormmy anderson wrote:
> hello.
>
> i am a university student in the USA. I have the openoffice.org 2.0.
> my problem is that I am just trying very simply to create a table in
> openoffice.org base and I am having a problem I fill out the field name,
> the field type, and description. As the first field name I put Client
> Number and as field type I put text {varchar} and as description I put
> Client Number (Primary Key). and i do the rest of the fileds for the
> table I want to creat and as I have selected the field Client Number as
> the primary key... will you please tell me why it will not accept it?
>
> I close the window it asks me do I want to save changes made to table
> I say yes.
>
> then I get a message telling me no primary key has been set.
>
> How Do I do it???
>
> Please I would like to submit My simple database table project.
>
> Suzie
I recommend you download this file:
http://delewis.com/OOo/GettingStartedWithBase.odt from my web site. It
explains how to create a database.
Your specific problem is that the Primary key must have the field type
Integer[INTEGER]. If you want this field to be automatically be filled, you
need to change AutoValue from No to Yes in the bottom section.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
