B bugsy Registered User. Local time Today, 00:24 Joined Oct 1, 2007 Messages 99 Apr 8, 2008 #1 Is it possible for AutoNumber ID not to skip deleted IDs ? for instance if I deleted item with id # 5, I want the next record to have Id # 5
Is it possible for AutoNumber ID not to skip deleted IDs ? for instance if I deleted item with id # 5, I want the next record to have Id # 5
boblarson Smeghead Local time Today, 00:24 Joined Jan 12, 2001 Messages 32,040 Apr 8, 2008 #2 Then you have to create your own method of creating the number. An autonumber, once started and then removed will not come back.
Then you have to create your own method of creating the number. An autonumber, once started and then removed will not come back.
