[Solved] Inconsistent record numbering

[gkick]

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.

[Villeroy]

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.

[F3K Total]

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

Code: Select all

UPDATE "Table1" SET ID = ID + 1

now Menue View/Refresh Tables

[gkick]

Thank you guys