1 Reply Latest reply on Aug 5, 2011 9:21 AM by philmodjunk

    Tracking Single and Bundled Products (Choral Music Library)

    JohnWoods3256

      Title

      Tracking Single and Bundled Products (Choral Music Library)

      Post

      I am trying to track choral music in a music library. Some songs are single copies, yet others are members of a collection with multiple songs. The collection has it's own title. As best I can tell:

      A collection has a unique title, and multiple songs.

      A single song can also appear alone. 

      This is much like a CD, where a "single" is self titled, yet an album has multiple songs and a unique song title.  

      I can't figure out what tables I need to track this. 

      Thanks, 

      John