Hey Guys ,
my Question is the following suppose i have 4 records in the database and they have id 1,2 ,3 ,4 and i deleted the second one so now i have 1 ,3 ,4 so how can i fix this automatically and reorder them to be 1 2 3 .
i am asking this because when i create a new record in my vb.net application i am counting the number of record and incrementing it so now i have a record id of 4 and i can't create this new record because there is a record with that id .
thank you in advance for your help .
regards