In reference to the discussions on roll data-basing, particularly
regarding medley rolls, the trick I've used is to define a sequencing
variable field in addition to the roll serial number field. This
number (the sequence variable) is simply "0" for an entry corresponding
to the title of the medley.
For example, the collection entry for QRS 200499 with sequence variable
=0 is the title: "Medley of Song Hits From Current Broadway Successes."
I then proceed to list each of the individual songs on the medley, using
the same parent serial number but with successive sequencing numbers, in
alignment with the original tune ordering. The first tune, "Rose of
Washington Square" is listed under parent 200499 with sequencing variable
=1. And so on for all the tunes on the roll.
Using this technique, if you want to sort all your medley rolls JUST by
title of the medley, you simply query on parent roll number plus sequence
=0. This method also works well for nickelodeon rolls. Even if the
original roll didn't have a "medley" title (such as "Blues From
Dixieland", or something like that), you can name it by company and
number (i.e. Clark A-345).
Frank Himpsl
|