Apache OpenOffice Community Forum

Just an observation.
while testing updating a record with the current user name after changing a record I noticed that when I update record number 2 in the entry form I am actually changing record number 1 in the underlying table since table records start with 0.

You can start the ID numbers with any integer number and increment with any integer other than 0. The auto-value is not a concrete row number. It is a unique index number distinguishing one record from another. It would still work if it were generated as a random integer.

if you want, in an allready filled table, to raise the ID by 1 you can use via Tools/SQL... now Menue View/Refresh Tables

Thank you guys