Sorry for not getting back earlier out of office yesterday.

A big thanks to everyone that has responded to this thread, you've put my mind at rest regarding this now seemingly rediculous...

Hi Merrill

I totally understand what you and Chris are saying about real and surrogate keys. This question of mine was soley for the cleanup of gaps caused by insert record...

Chris >> It doesn't make any difference to the db at all, just to me

Good point Steve, on production it's acceptable without a doubt on deletion of a record. I'm really talking about inserts in my dev system before pushing to production, that's all....

Hi Guys

Thanks for the comments posted, I really appreciate your thoughts

Remi >> I don't have that problem here where an id has to be accounted for, and by the sounds...

Hi

Your question is a good one.

This will only be a problem whilst under development, if it happens on the production server then so be it, but I would rather it didn't...

Okay, I've been playing around with fixing a table and came up with this so far. Haven't tested on a PK linked to a FK yet.

Any comments folks, am I...