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 record 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 record… the next record don’t put the correct autovalue, so the if last record was 37, when I add a new record the autovalue says the next record to 37 is 40 !!! and that is incorrect, it doesn’t follow the correct number ordering, it should 38 and not 40… the autovalue is crazy…
The last 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?