How does the script fill in ID numbers of records that were deleted from the DB, now I have number 80 waiting for someone, who adds a record, and there are only 55 records in the DB, so number 5,8,11,... is missing and the ID numbers are not following up each other. Can I solve this problem???
I've seen the answers in forum Forum5/HTML/000794.html, but this is alright by me.

I don't think it is possible to do what you want. The other thread is talking about something that is very wrong with the database and there will be other problems that come along with it. (I still haven't figured out how it happens, though.)

What is it that you want to accomplish by filling in the missing numbers?


------------------
JPD

Nothing special, only the look, that the number of records are corresponded with the ID number, and the idea, that the ID number one time goes over his top. Also the feeling, that everything is "under control", but thanks for the quick reply.