Hello all!

I'm about to start on a project that is bigger than anything I've ever done to this point and will be database driven Web site for a band.

On paper, this is what I've got for my database:

  1. memberID
  2. memberName
  3. memberPhoto (link)
  4. memberBio
  1. albumID
  2. albumName
  3. albumLabel
  4. albumYear
  1. trackID
  2. trackName
  3. albumID
  4. trackLyrics
I think that's it ... anyway, my challenge is, over the years this band has had member changes etc. I want to have it so each album listing has a listing of the members who worked on that album. I'm having problems conceptualizing how I'm going ot efficiently build that.

Any suggestions?