Music Dept. Inventory Database User Guide
×
Menu
Index
 

Utilities

 
 
Sheet Music Utilities
 
The Sheet Music Utilities screen allows you to add/edit/delete records for all the Lookup tables used in the Drop-down boxes on the Sheet Music screen.  They all have the same features - you can add new records, edit existing records and delete records.  Be aware that if you delete a value in a Lookup table any Sheet Music records that use that value will have a blank value in the field.
 
 
Here is a sample of the Instrument / Choir parts table.  The Add Record button allows you to add a new record.  The "X" button on each line will allow you to delete a value.  Be aware that if you delete a value in a Lookup table any Sheet Music records that use that value will have a blank value in the field.
 
 
The Storage Location is a two part list.  The Main storage location is listed first (i.e. Music Room, Choir Room, etc).  Then shelf/bin details are added for each location.