I've just started shooting film again, and have been pondering this very question. Here's how I've started (currently, I'm just having the lab do dev/scan, but that doesn't really affect the process):
First, I started a numbering system. My first roll is R00001 (as if I'll ever shoot 99 thousand rolls of film
🙂). Obviously, each roll thereafter is in sequence.
When I get the negs and CD back from the lab, I use a sharpie to mark the neg sleeve with the roll number and date I picked up the negs. I mark the CD with the same number and date.
Here is the key for me - use software and a tagging system:
I then import the CDs images into Aperture (my preferred digital workflow tool). I generally just import them into an Aperture project with a name corresponding to the import date. If the set of photos is very thematic, I'll include that after the date. I
immediately "tag" the photos with the
roll number. Now, my negs/CD/scans all have something in common -- so they are tied together forever.
I then go on to tag the photos with all the other important stuff (film, ISO, location, subject, style, camera, lens, etc.). If I really care about the exact date the photo was taken, I'll update the metadata for that, too (generally I don't care that much).
Now, if I want to find an old photo, I'll search for it in the software by tag or tags. Example: "downtown littleton store window". That will vastly narrow down the images in my database. When I find the actual image I'm looking for, I'll also be able to see its roll number. I can then go to the bookshelf and find the CD/negs. Bob's my uncle
🙂.
Here's an example of finding a photo on flickr using "downtown littleton gate" as my tag search:
http://www.flickr.com/search/?w=76198982@N00&q=downtown+littleton+gate&m=text
Click on the displayed image. Note how the image has a tag of R00001 (over to the right). That would lead me to the correct neg page or CD, should I ever want to have a large print made.
Obviously, this is computer-centric. I use a Mac, so I'm pretty religious about backing up (use Time Machine), plus I use Aperture's back-up facility onto a separate disk. Most of the photos I like get uploaded to flickr (which keeps the tags) as well, so even if all my backup disks die, I can still get to my negs by roll number.