Set starting number for auto counter?
I have an existing auto incremented ID in my data, how do I set the starting point for an auto incremented field?
Changing the number in the table builder does nothing. The auto counter continues from wherever it last left off. (Like it is being tracked by SQL or some other process).
I had the same issue. When importing data from the "classic" system, I tried to continue the numbers where the old system left off, didn't work.
I started my Auto Counter at 16001, but on the seven records I've put in the table show the counter numbers: 16003, 16004,16005, 16024, 16025, 16026, 16027.
I don't know why it goes to these numbers, I tried starting them a 1 and 15001 and it does the same number pattern?
Derrick Kotlus commented
The number the auto counter starts at can be changed in your table builder. After clicking on the field in the center column, you will be presented with an option to chose a starting number.
Hope this helps!