My business involves maintaining a very large database of information about the digital photographs which we license for reproduction. Based on 30 years of experience I would offer a particular suggestion if you are intending to keep digital images of the firearms recorded in your spread sheet. The most unique thing about any firearm is its serial number and over time you will experience far less aggravation if you adopt the actual serial number as the primary ID for each firearm record, Then use this convention for naming and storing your images: use the serial number and if you have several shots of the same firearm use the convention of using an underscore and a sequential number after the underscore for each image, e.g. 200000_1.jpg, 200000_2.jpg, 200000_3.jpg It is highly unlikely that you will have more than one firearm with the same serial number.
And remember to always, always BACKUP your spreadsheet to a second drive every time you make a new entry or make a change - an inexpensive flash drive is ideal for this.
__________________
Bob Roberts
|