Announcement: Spring Fundraising Drive In Progress

Please visit our home page to see this and other announcements: https://www.mmdigest.com     Thank you. — Jody

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 Thu, 7 Aug 1997 21:32:20 -0700 , from time zone -0700.)

Key Words in Subject:  Collections, Databases, Roll

Please Support Publication of the MMD with your Generous Donation
No PayPal account required

 

SSL Certificate
by
Let's Encrypt