Equipment Inventory Database User Guide
Costume Inventory Resources -


Sound Utilities
1)  View Software Registration - shows the Software Registration Key.
2)  Database Statistics - this will give you a count of the records for all the Equipment.
3)  Re-Index Tag ID's Sorting - The database records have an internal sorting key that is updated when records are added.  Occasionally the key needs to be updated.  If you renumber equipment records it is a good idea to update the sorting.
4)  Set up Folder for Photos - This screen allows you to enter the name of the folder on your server or computer where the photos are stored.  It makes it easier to add photos to your Equipment records.
5)  Update Storage Location for Select Equipment
If you have recorded a Storage Location for several pieces of equipment and then move them to a new location you can do it one record at a time or use this utility to select a group of records and then change the Storage Location for all the selected records.
In the example above:
1)  Select the new Storage Location.  In this case - Main Closet - Shelf 2.
2)  Select the records to update.  You can do this my checking the check box for the record or using the drop - down box to select the record - or put the cursor in the box (#2) and scan the inventory label's barcode scanner.
3)  All selected records will have a check mark.
4)  The number of records selected will be shown at the bottom.
5)  Click the "Update" button to update the selected records.  (Main Closet, Shelf 6 will be updated to Main Closet, Shelf 2).
Update Lookup tables.
All the drop-down boxes are based on tables.  You can add, edit or delete values in all the tables.  The Lookup table forms are all very similar.  Here is a sample of the Storage Locations form.    If an Equipment record uses a value - such as Cable Wall 1 (in this example) and you delete the value (Delete Location), then the Equipment record will not show a Storage Location on the form. 
On most forms the "X" to the right of each value is a "Delete" key to delete a value.
The online help was created with Dr.Explain