Music CD Database

[Duncan]

I'm thinking of creating a Music CD database in Access
2002. I'll have the usual Artist, Release Date, Label,
Genre, etc. My problem is how to go about adding the
individual track info (what's on each disc). Has anybody
done this before? I can't think of a good way to
implement this.

Cheers

 

[Duncan]

Thanks a lot for the helpful advice.

 

[Duane Hookom]

This has been asked a few times in the past. I recommend tables:

tblArtists (one record per artist)
artArtID pk autonumber
orther fields about artist

tblCDs (one record per CD)
cdsCDsID pk autonumber
other fields like Title and notes
maybe cdsArtID for primary artist

tblTracks (one record per Track/Song)
trkTrkID pk Autonumber
trkTitle
trkSeconds
trkArtID (if you only want to store
one artist per track)

Do you want to track Genre and if so, by CD or Track or Artist or all of the
above?
If you want to track individual artists on each track or CD like:
Diana Krall - Piano, Lead Vocal
Russel Malone - Guitar
Christian McBride - Bass
you will need to set up additional tables.