[Solved] Primary Key - Can't Find "AutoValue"

[Hurley]

I'm trying to set a Primary Key in my Table, using the "AutoValue" option. However, I can't find the "AutoValue" option. I've followed the directions under help and on the OpenOffice site but I'm never given the option.

Can anyone help me. I'm using OpenOffice 3.3.

Thank you.

Here are the directions I tried to follow:

Table Design

This section contains information about how to create a new database table in the design view.
Open the database file of the database where you want a new table. Click the Tables icon. Choose Create Table in Design View to create a new table.

In the Design view, you can now create the fields for your table.
Enter new fields in rows from top to bottom. Click the Field Name cell and enter a field name for each data field.

Include a "primary key" data field. Base needs a primary key to be able to edit the table contents. A primary key has unique contents for each data record. For example, insert a numerical field, right-click the first column, and choose Primary Key from the context menu. Set AutoValue to "Yes", so Base can automatically increment the value for each new record.

In the next cell to the right, define the Field Type. When you click in the cell, you can select a field type in the combo box.

Each field can only accept data corresponding to the specified field type. For example, it is not possible to enter text in a number field. Memo fields in dBASE III format are references to internally-managed text files which can hold up to 64KB text.

You can enter an optional Description for each field. The text of the description will appear as a tip on the column headings in the table view.

[r4zoli]

Autovalue settings allowed only in integer datatype field, possibly you try to use it on other datatypes.

[Hurley]

Thank you. The instructions under "Help" do not indicate that you need to set the data type on [INTERGER]. Once I did as you advised, the "aotovalue" choice came up.

Now, the only problem is how to set this kind of key after I've already input some data. I couldn't figure that out so I just deleted the data I had, added the new primary key and input the data again.

Thanks again.