Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I represent three-dimensions on a form? CrossTAB?
Message
From
15/09/2000 09:19:01
 
 
To
13/09/2000 18:39:19
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00416181
Message ID:
00416820
Views:
22
>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

Hi Sandy,

I am not sure if you are asking how to set up the database to accomodate the nature of the information, or that you have already done this and want help on displaying the data in a form understandable to the user...?
Phil
_____________________________
Phil Miles
http://www.philmiles.com
phil@philmiles.com
Previous
Reply
Map
View

Click here to load this message in the networking platform