I've took advantage of Warner's DVD-to-Blu offer and traded a bunch of my DVDs in for Blu-Rays. As I shipped the physical DVDs away for good I removed them from my collection. While waiting for the Blu-Rays to be shipped back I naturally bought some new Blu-Ray discs and entered them into my collection only to discover much to my surprise that it assigned them the very low numbers that once belonged to the DVDs I shipped off to Warner.

As my collection (in the several thousands) is stored in binders (by collection number) as it wouldn't fit anywhere otherwise, the collection number is a big deal and, naturally the new discs I've purchased are multi-disc sets which were assigned the old low number of a single disc DVD.

Obviously this is a huge problem. I'm okay with empty numbers, in fact being used to the concept of key numbers in a database it never even occurred to me that a number would be reused - unless I forced a renumbering.

So my question is, is there a way to prevent this from happening or do I need to go through the database, find the number gaps, and fill them with some sort of "null" record? I just received the Alien Anthology, and I shudder to think of DVD Profiler splaying the various discs out all over my catalog.

Thanks!
-greg

Thanks. Fortunately I have an older archive of my database so I'm going to use it to reconstruct what was deleted.

-greg