Double Entry – how to fix

[Klaus Bundies]

Hello, I have a simple Database with a Project No. field that increases by 1 every new entry.
I have now noticed, I have two entries with the same Project number:
46, 47, 47, 48, 49, 50. Note that 47, 47 are two different entries, I have to keep them.
How can I fix this (editing the entries to 46, 47, 48, 49, 50, 51 – so that the next new entry will be 52)?
Thank you for helping.

• This topic was modified 3 weeks, 2 days ago by Klaus Bundies.

[Brendan]

Hi Klaus,

If you only have a few entries to renumber I’d suggest just doing it by hand. If you have the auto-increment setting enabled for your Number field, just turn that off temporarily. Edit the project number field values to how they should be, then re-enable the Auto-Increment feature on the Number field and then set the Next Default Value setting to 52.

Thanks,

Brendan

[Klaus Bundies]

Thanks Brendan for your incredibly fast reply.
Thanks to your help I was able to fix this in less than a minute :)
Also after re-enabling automatic increment, next entry correctly follows up with 52 :)
Klaus

• This reply was modified 3 weeks, 1 day ago by Klaus Bundies.
• This reply was modified 3 weeks, 1 day ago by Klaus Bundies.

[Author]

Posts