I've been using Music Collector (http://www.collectorz.com) for a few 
years now and it's just a brilliant, easy to use piece of software. It's 
a little more costly now than it was when I bought it, but you get free 
upgrades for life, so that counts for something.

It does every single thing you've listed below - and has an easy export 
feature in case you want to, say, publish your list online (or keep 
printed records).

Now not only do I know how many CDs (and LPs and tapes) I have in my 
collection, but it also ads up the value I've assigned to each item so I 
have a nice number I can submit to home insurance.

joe

Ken Kase wrote:
> OK, this is what I'm looking for:
>
> I want to be able to generate lists of participants on albums. In other
> words, if the album was produced by Mitchell Froom, I want to be able to
> view all albums produced by him. If Art Blakey played the drums on a whole
> bunch of albums, I want to generate a list of all albums he plays on. Record
> labels, year of release, etc.
>
> I also want to be able to extract individual artist's tracks from
> compilation CDs. So if the Sonics appear on three compilation CDs, I want to
> be able to see a list of all the tracks containing the Sonics at a glance.
>
> How about that?
>
> --Ken
>