Perhaps you need to think of this as being heirarchical rather than 3-Dimensional. A warehouse contains aisles which contain levels which contain pallets which contain inventory. This would allow you to use a container paradigm which would fit very neatly within our object-oriented paradigm.

You could use the Treeview activex control for an Explorer-like interface.

-cjh

>Hi I have an inventory allocation problem and need some help. My application needs to accomodate inventory bins. The bins are represented by three axis - Aisle, Level and Pallet. A warehouse has x many aisles, with shelves representing the levels and pallets representing the positions. I need to build this data representation, so I can determine if the location is full or empty, and if full contains the same product. Parts of the warehouse (partial aisles, or entire aisles) may be offlimits and so these need to be marked as unavailable. Ultimately, I will need the computer to use the inventory positions to determine FIFO (recommending which bin to pull product from), and at some point warehouse utilization - what percentage of time and what percentage of use. I am thinking that Cross tabs may work, but I have never done any and can't figure out where to begin (ie. build a view then possibly build a crosstab view (dont know if this is possible). Can someone give me some ideas and some
>basic where to start??
>
>Thanks for the help!
>
>Sandi Cassidy