Mechanical Music Digest  Archives
You Are Not Logged In Login/Get New Account
Please Log In. Accounts are free!
Logged In users are granted additional features including a more current version of the Archives and a simplified process for submitting articles.
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   


Enter text below to search the MMD Website with Google



CONTACT FORM: 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-2024 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

Please Support Publication of the MMD with your Generous Donation

Pay via PayPal

No PayPal account required

                                     
Translate This Page