# Read me

comment:
disk - each set has 1 or more disks, each disk belongs to only 1 set, 1:m relationship


comment:
track - each disk has 1 or more track, each track belongs to only 1 disk, 1:m relationship


comment:
first I created the track form (using Wizard), a tabular form listing all tracks


comment:
then I created a columnar disk form (Wizard), and inserted the track form as a sub form


comment:
then I created a columnar set form (Wizard)…


comment:
…and inserted the disk form as a sub form within the set form (it worked! I now know you can have subforms within subforms).


comment:
then much messing about to get the forms to display in a vaguely reasonable fashion


comment:
the various forms do need to show the repeated CD and disk nos., but, while testing at least, it is reassuring to see that the right details are being picked up.


comment:
to get rid of the 'new record' line at the end of the track list, set 'allow additions' property for the track form to 'No'.


comment:
simple report to list all CDs in title order - using Wizard then moving stuff around for better layout.


comment:
improvements to design would be to have an artist table and a title table, then use these as combo boxes on the forms.


comment:
this would need a third extra table (appearance = artist + track) to resolve the m:m relationship


# Set

CD Details:
M&S Compilation - "An evocative introduction to the blues. Original artists, original recordings".


CD Details:
Triple CD set celbrating 100 years of great Jazz. EMI


