Unable to set-up Primary Key Ver 6.2.0.3 (x64)

[AndeAnderson]

In Base, Ver 6.2.0.3 (x64) I am unable to set-up a designated Primary Key with AutoNumber. Help says:

“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.”

When I right click on the Field I get a Standard Context Menu for Undo, Copy, Paste.
When I right click on the “Field Name” for the column all I get is “Column Width”.

Since that doesn’t work, how do I assign a Primary Key with AutoNumber?
Thanks

[mariosv]

Please, if the answer solves the question click .

[Ratslinger]

Hello,

First, here is the link to the LO documentation → LibreOffice Base Handbook. Chapter 3 - Tables should be of help.

Create table in Design View presents first:

Then you enter (based upon using an auto increment key field) a field name and a field type:

Then change AutoValue property to Yes and then select a new line in field names:

you will see the key field is set to left of the ID field. You can always set the field yourself by right mouse clicking that area to left of field name and the selecting Primary Key from context menu: