Sandi;

Perhaps you are being too literal about mapping the organization of the information to the organization of the warehouse. hink about the flow of information, instead. Does the user go into the program knowing the aisle and shelf? Probably not - they go in knowing the parts they wanna pull and just wanna know which ones to pull. Stockers know what they're bringing in and wanna know where to put it (I'm guessing - just an example).

Sure, you may want a more visual method of explaining to the user where to go - but that's the final product, not the starting point.

I may be off base on this, because I don't know exactly the workflow you're automating - but perhaps it will help.

Michael

>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