Hi,
This is my first post so please excuse my ignorance if I'm calling something the wrong name.
I have been managing a large Database for the past 7 years, with very little knowledge of the workings of a Database(but I have picked up a lot along the way).
At the end of each year I simply tae a copy of the current years database, remove all the data and reformat some of the fields to create a new years database.
I have a commitment table that holds a unique ID for each record. The format of this is a 6 digit number and I simply change the first digit at the stat of each year in the table design.
My problem is that now we are in year 7 we are about to go over the Commitment ID 799999 and I'm not sure what to do to fix it.
Is there a way of making the database forget that it as used the previous yeas numbers so that when the first commitments added for the new year it will appear as 70001?
Thank in advance for ay help.