I recently noticed after making some adjustments to my collection that there are gaps in my collection numbers. One dvd doesnt even have a number. If I reassign them how does it prioritize? By date added? Alphabetically? I haven't attempted it yet because I don't want to F it up.

Any enlightenment would help. Thanx!

Thank you much!

DBQuery can be used to find gaps/duplicates in collection numbers if you don't want to re-assign.

I mean't if you just want to fill the gaps and/or remove duplicates.  I use collection numbers for trailers so I wouldn't dare use reassign in case it changed the existing numbers  .

Quoting hydr0x:

Quote:
[...]
But if you fill the gaps that way you'll end up with a nr 200 that's been bought 5 years after nr 201??
[...].

I don't use collections numbers to tell me when I bought a dvd, I use purchase date for that 

I use it to see how many dvds I have as I don't number any children (box set=1) and use it alphabetically.  Ziggy is always last!   Occasionally when looking for a movie, I'll go to a certain letter, say "s", and look through those for choices.

curious to know from others here.., How many of you have every one of your dvd purchases with the date purchased/price paid/ and where you bought it?
I know it is a big challenge to fill in ALL these fields, but the date purchased field, would be a godsend in knowing that your reassignment of collection numbers could never be lost as the dates would be a good indicator of what your first and 500th purchase date could relate to your library of titles.
When I first used/purchased  Intervocative ( Invelos today) back in April 2001, I had been using it for maybe a year or so until my purchase date later, but at that time my library was quite small, and I filled in the dates of purchase from another program I was using since 1997 , and had all prices locations and dates in the fields which I printed out and used for Intervocative's fields ..

so was wondering if this field is greatly used by all...  ??

no guessing now....