[AccessDevelopers] Graphical Inventory

Thu, 15 Sep 2005 13:45:35 -0700

I have a project that I think goes beyond what Access is capable of, but am not sure where to find suitable software either.  Perhaps someone has some ideas.
 
My client has a food processing plant with a huge freezer.  In the freezer, there are "lanes" for pallets to be stacked in.  The pallets are placed in stacks of 3-5 "layers" up to maybe 15 "slots" (or stacks) from the wall.
 
Product is moving in and out of the freezer constantly, and the forklift drivers many times have trouble finding where pallets are located.
 
What the client wants is simply a database solution that contains a map of the freezer with all its lanes, slots, and layers (it is fine for the layers to be shown from left to right across any lane-slot location, so we're not talking about 3-D).  Whenever a lot (10 pallets) is moved into the freezer, the forklift drivers should be able to quickly mark on the computer where they placed each pallet.  For each pallet, they need to mark the wieght of the pallet, the lot #, and the # of buckets on the pallet.
 
When pallets are rearranged, the client wants the drivers to be able to simply click and drag pallets from one location to another.
 
There is no permanent information they want to record (they already have an inventory database) -- they just want a way to easily keep track of what is where in their freezer.
 
I can envision designing an Access database that might be suitable, but I'm not sure how "pretty" I could make it.  Is there even a way to click and drag items around on a form?
 
So here are my two questions:
 
1.  Does anyone know of a software product out there that would be ideal for this project?
 
2.  Is Access capable of more than I am giving it credit for?
 
TIA,
Toby



Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to