Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How may I set up the auto-value countering for a primary key in Base?

Hello I have a LibreOffice Base table, and it has a Primary Key, which is an INTEGER and it has 37 registries. The primary key was set-up as autovalue, because what I want is to move forward adding new registries and the value add +1, that is if the last value was 37, the next registry would be 38, 39, 40 and so on... The problem is (and I don't know why is this happening) that when I add a new registry... the next registry don't put the correct autovalue, so the last registry was 37 and when I add a new registry the autovalue says the next registry to 37 is 40 !!! and that is incorrect, it doesn't follow the correct number ordering, it should 38 and not 40... The last registry in the primary key was 37 The next one should be 38 and not 40 (as the autovalue suggest that is the correct number, 40, for the next record) How may I correct the autovalue to make it follow correctly the next number and put 38?

How may I set up the auto-value countering for a primary key in Base?

Hello I have a LibreOffice Base table, and it has a Primary Key, which is an INTEGER and it has 37 registries. The primary key was set-up as autovalue, because what I want is to move forward adding new registries and the value add +1, that is if the last value was 37, the next registry record would be 38, 39, 40 and so on... on...

The problem is (and I don't know why is this happening) that when I add a new registry... the next registry record... the next record don't put the correct autovalue, so the if last registry was 37 and record was 37, when I add a new registry record the autovalue says the next registry record to 37 is 40 !!! and that is incorrect, it doesn't follow the correct number ordering, it should 38 and not 40... 40... the autovalue is crazy...

The last registry record in the primary key was 37 The next one should be 38 and not 40 (as the autovalue suggest that is the correct number, 40, for the next record) How may I correct the autovalue to make it follow correctly the next number and put 38?