The recent post by Jim got me curious as to how others catalog their collections and I’d be interested to hear not only how you do it but what (if any) legal requirements there are that govern this.
A requirement of an ammunition collectors license in Western Australia is that a log of every item is maintained and that it must specify where/who you obtained the item from. Also, we are not allowed to have live rounds 20mm or above. Below is a screen capture from the Access database I built.
Most of the fields are drop-down, search as you type fields, meaning it is very quick and easy to input data. In the example above the keystrokes to populate the data fields were as follows:
mj [tab] au [tab] 1942 [tab] r [tab] .303 [tab] xx [tab] 250916 [tab] [tab] then I type in the description. Ican type as much or as little as I want in here, including links to web sites etc.
The xx represent the first two letters of the name of the person/supplier I got the item from. The status field defaults to LIVE, so I only have to type Inert if it isn’t a live round. The pictures load automatically once they have been sized and saved using the record number as the image name.
You may be wondering why there are so many categories and this is so that I can easily find a round using the filter (search engine), which is shown below:
Here I have searched for all my Australian 303 British rounds made in Footscray between May 1926 and 1962 (when they used the MF code). I can click on the column headings to sort them alphabetically/numerically. In this example, I have sorted by year. However, I could click on the Comments column and sort by round type and mark.
If there is sufficient interest, I’d be happy to make this available to others. It will take me some time to write a manual.