Hey folks,
I am attempting to build an Inventory Control database, and I have a question regarding Location info.
At our plant, we have three separate storage locations, I'll call them Warehouse1, Warehouse2, and PIT (for Powered Industrial Trucks - for the PIT mechanic).
In WH1 & 2, our current labeling system is like:
Aisle, Section, Shelf. So it looks like 1,A,1...15,D,7.
Or CAB A, CAB FUSE...
I started to create a Locations table, but I would have to type in EVERY single location.
But, I need a simple way of allowing the Parts Manager to select the Location every time he adds/moves parts.
Should I continue with the Table I started or somehow use separate fields/controls for Aisle, Section, Shelf?
So, like a combo box with a listing: 1A1...CAB J? Or allow each field to be selected individually?
Or some other idea?
thanks.
I am attempting to build an Inventory Control database, and I have a question regarding Location info.
At our plant, we have three separate storage locations, I'll call them Warehouse1, Warehouse2, and PIT (for Powered Industrial Trucks - for the PIT mechanic).
In WH1 & 2, our current labeling system is like:
Aisle, Section, Shelf. So it looks like 1,A,1...15,D,7.
Or CAB A, CAB FUSE...
I started to create a Locations table, but I would have to type in EVERY single location.
But, I need a simple way of allowing the Parts Manager to select the Location every time he adds/moves parts.
Should I continue with the Table I started or somehow use separate fields/controls for Aisle, Section, Shelf?
So, like a combo box with a listing: 1A1...CAB J? Or allow each field to be selected individually?
Or some other idea?
thanks.