Like many of us in this hobby, I have many more locomotives and rail cars than I could ever run at one time and keeping them organized has been a challenge for me. Sometimes I acquire something that I already have because I forgot I have it, sound familiar ? I have tried to use spreadsheets to keep track of things but the files ended up getting lost or corrupted. So I thought I would try using the inventory function of the data base as it will be on a server somewhere and someone other than me is going to back it up, etc.
As I enter my collection into my inventory I am placing a color coded sticker on the box with the data base reference number on it. Having the sticker will tell me that the item has been included in my inventory and the sticker color will indicate which era on my layout it belongs to.
This Post from back in 2014 I explained how I was planning to have 3 different eras on the layout.
I purchased some adhesive stickers in different colors and write the inventory ID number on these while at the same time setting the era.
The GP9's in this photo all have the same ID number on the sticker. That's because I had bought them as non numbered models and put the numbers myself.
It's nice not having that box of extra engines sitting on the floor. Hopefully I can keep this going and have a more efficient railroad.