On 8/22/09 users-digest-h...@openoffice.org wrote:
Subject:
Re: [users] Importing to Base - Solved (Mostly)
From:
Brian Barker <b.m.bar...@btinternet.com>
Date:
Sat, 22 Aug 2009 06:51:43 +0100
To:
users@openoffice.org
At 11:26 20/08/2009 -0500, Michael Reich wrote:
One thing I can't figure out at this point is how to get that new key
field to auto-increment when adding a new record. The help files
talk about selecting an "auto increment" (or something like that)
property, but I can't find that anywhere. Sigh.
o If you use the wizard to create your table, you will see "Auto
value" boxes on the third panel ("Set primary key").
o If you create your table in Design View, any field to which you
ascribe the Field Type "Integer [ INTEGER ]" will show AutoValue
amongst the Field Properties at the bottom of the window. (Select
"Yes".)
o For an existing table, select it in the Tables panel and go to Edit
| Edit... (or right-click | Edit) to reach the same view as above.
Select the relevant (integer) field to see the AutoValue property.
I trust this helps.
Brian Barker
Thanks Brian. Problem was I had the key field set to be a numeric, not
integer. When I changed it to integer, the property appeared as you
described.