Tim,
We've struggled with the same issue for many years, and as our inventory of audio visual equipment and exhibition furniture, both custom and standard, has grown, we've had to get more serious about tracking and labeling. Our tracking system started as an excel document with different tabs for different types of materials that we track. When this proved to be too unruly, we started exploring different tracking techniques.
We've explored FileMaker and Access - both are neither intuitive nor user friendly and there is a huge learning curve in figuring out how to build and maintain a database. We worked with an Undergraduate Engineering class here at Yale to explore every step of the process - warehousing, transportation, tracking, and labeling. The students used an MIT app builder to design a very theoretical app that would scan RFID tags. RFID (Radio frequency identification) tags were preferable to barcodes because we would be able to scan them through a 1/2" of mdf medex. In the end, the students learned a bit about technology and we learned how to think pragmatically about how we may benefit from technology after many hard conversations with our museum IT director.
Taking all this into account, I started looking for a cloud based asset tracking subscription that wouldn't required upkeep by our IT department and could be used with the technology that we currently have. After a few 30 day trials, I settled on Asset Panda. I like it because it is customizable and geared toward tracking assets. Each asset has a digital card with custom fields I've made: name, location, mauf. size, dimension width, dimension height, dimension base, build by, category (AV, Case, Pedestal, Frame, Platform, Crate, Exhibition Furniture Component), fabric color, hold for exhibition, serial #, status, area, color, notes, case type, case contents, model, reserved. You can also upload and link a photo to the record. This is huge for me. We've taken photos of all the casework in the gallery and linked them to the case record card. This is relatively easy because Asset Panda has an app for iphones and ipads.
This said, I understand that your question is about physically tagging or marking display furniture. I think if you are not able to permanently label material, you second best option is to have a tighter tracking system. Know what you have and have the ability to easily change locations and track material. One of the functions of this tracking system that has really saved me a few times has been the report function. If you mark an asset as reserved for a particular exhibition in it's record, later running a report can be a reminder for changing locations. The report function can also be used in several different ways. You can save report types that run different filters. For example, lets say you want to know how many pedestals you have in the warehouse that are white and 50"H. This is super easy to do with the report function.
Hope this helps. Let me know if you have any questions.
Thanks,
Anna
------------------------------
Anna Russell
Museum Assistant for Exhibitions and Collections
Yale University Art Gallery
New Haven CT
------------------------------