How would you design this???

[betheball]

I want to create a database to track my extensive CD collection. What I am wondering is the best way to design the db. For example, I want to record the Artist, CD Title, each track and perhaps the release date. The part that confuses me, is how best to capture the tracks since the number of tracks varies from cd to cd. My hope is to use an Access db as a backend only and then create some forms in ASP to actually enter data. Again, the problem is what to do with the tracks, since it is not a set number. Would it be best to just have a separate table for the tracks but then also include a column for the CD ID#?

Please share your input on how you would handle a project such as this.

 

[dgm]

Yup. Have one table for your CD info
tblCDs
cdID
cdName
cdArtist
etc

And one for tracks:
tblTracks
trkID
cdID
trkName
trkLength
etc

Then bind your main form to the tblCDs and create a subform bound to tblTracks, linking them via cdID.

 

[Pat Hartman]

Here's a link to a template that you can download. It should get you started.

Music database template

 

[betheball]

Outstanding. Thanks Pat.