Two Heads Are Better Than One
I need some help from you readers. My local scuba shop wants to set up an inventory control system for their rental equipment and they’ve asked me to help. I know what I want but I can’t find it out there. Maybe you can point me in the right direction?
What we’re going to do is barcode all the equipment so we can scan it to check it in and out. I need two things to make that happen:
- Some kind of database with tables made up of the equipment being rented and the customers renting it, and then need a front end on it where we can plug in who’s renting what and when they return it. We don’t need prices or invoices, just in/out.
- A way to get the barcodes on the equipment. This is scuba gear, remember, so it’s going to get beat up a lot, not to mention being underwater for extended periods of time. We need something durable that won’t get in the way. I’ve seen something like a cross between a zipper pull and a zip tie that looked close to what we need but I can’t find it anywhere.
I was thinking Access might be the way to go but I don’t know it well enough to set up the tables or design the interface.
So there you go, that’s what I need your help with. If you can point me to a cheap Windows-based software solution and a durable inventory tag, I’ll sure appreciate it. Maybe I’ll take you diving with me as thanks.
Can you help? Puh-leaze?
I put something like this together to manage our book archive/library at our publishing company. I used a couple of relational FileMaker Pro databases (one for the titles, one for the “customers,” etc., and bought a bar code scanned that sends the title info right into one of the FMP fields. It worked.