Autoincrement number to be changed

Hi All,

I have an autoincrement number

example 9800001

but the actual number should have been 7800001. Now that the users have used some numbers using series 9800007.
I want going forward the numbers should autoincrement using series 7800008.

Any suggestions would help

Well Rishyraj, I hate to be the one to give you some bad news, but you won't be able to do what you want. As you can see 7800008 is less than 9800007 so you can never make the autoincrement start from a number less than the current max number in the table. This is exactly the reason autoincrement should never be used for anything except to index tables by in relationalship databases.

What I would recommend if you can change the table design, is to change the current autoincrement field to a number, add a new field that is autoincrement and make this the primary key field. Then you can make the loan ID number any number you wish. You can then use the DLast function to find the last number in this field and add 1 to it to get the next number in sequence.

lwells