Whoops, I should refresh before I reply...

The way I understand it, there never should have been records deleted from this table, and it's a awfully big coincidence that the gap...

Well, I did inherit the table...

I've been looking for a way to insert the 55 records and have [PoolID] start at the next available number (671). I found instructions for...

That was an excellent article - I did some research a while ago about the best way to approach this project, but I don't remember seeing the "one row assumption"...