I have a table in sql server 2005 that holds a unique number that is auto incremented against all new entries. So, entry 1 is set to the unique key 1, entry 2 is set to 2, entry 3 to 3, but entry 4 to 5.
I was was playing about with the database and deleted one of the rows (4) and now the auto incrementing number runs like this:
1 = 1
2 = 2
3 = 3
5 = 4
6 = 5
7 = 6
And now when I want to display the information in an ASP page, the two obviously dont match, is there any way i can resolve this issue so everything is once more in sync?
There seems to be alot to take in, a lot of new terminology / information for a newbie, if only you could see my confused face right now, lol.
Just like to say thanks for all your post so far, but I have decided to drop it and move on to another task that has been presented to me, as it needs to be completed by the end of the month - and yes im stuck with that too.