Mechanical Music Digest  Archives
Home Archives Calendar Gallery Store Links Info
MMD > Archives > August 1997 > 1997.08.09 > 10Prev  Next


Databases for Roll Collections
By Bob Billings

In personal correspondence with Paul Johnson he brought up the problem of
listing titles with multiple sub-titles, such as medleys.  He wanted to
group the sub-titles together with the main title, with the main title
first and the sub-titles following.

We have a relatively simple solution we use.  We add a field to each
entry, coding it as a main or sub-title.  The roll number is the same
for both main and sub-title.  When you sort, the first level is by roll
number, then by this additional field.  This produces the desired result.

We also enhance things a bit by listing the main title in the "COMPOSER"
filed of the sub-title, and for printout purposes the main title is all
caps and the sub-title uses lower case.

Bob Billings


(Message sent Fri 8 Aug 1997, 04:32:20 GMT, from time zone GMT-0700.)

Key Words in Subject:  Collections, Databases, Roll

Home    Archives    Calendar    Gallery    Store    Links    Info   



Click HERE to write to the editor, or to post a message about Mechanical Musical Instruments to the MMD

Unless otherwise noted, all opinions are those of the individual authors and may not represent those of the editors. Compilation copyright 1995-2008 by Jody Kravitz.

Please read our Republication Policy before copying information from or creating links to this web site.

Click HERE to contact the webmaster regarding problems with the website.

Please support publication of the MMD by donating online

Pay via PayPal

No PayPal account required

                           
Pay via Amazon
Amazon Honor System Click Here to Pay Learn More
Please do not use
the anonymous option!
                           
Translate This Page
. .