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