jwlarson3rd you asked a very similar, if not identical, question here. And I'll respond in kind by repeating the reply I gave then. Like the other monks have pointed out, an unbroken sequence of ids is unnecessary. And though there are potential holes in my method of displaying records with Next and Prev buttons (I'm relying on the DB returning records in order), I have not experienced problems. However, to shore it up a bit (to address the concerns of mpeppler) you may be able to do some housekeeping with a hidden input statement, cookie, or flat file).

To your point of reclaiming lost ids, I have often wondered what happens if I'm using a datatype of TINYINT and exceed 256 because of deleting and adding records. So I have errored on the side of using datatypes that far exceed my needs.