-
Need some ideas
I have a question that I need help with. I am currently desinging my database. My First objective, I need to create a report that will group my store data but that has various thresholds that would preclude an item but then the item would then need to move to another bucket. Does that make sense?
For Instance I have a 1)XYZ Merlot,2) ABC Chardonnay, 3)GHI Cabernet, 4)TUV Reisling are all supposed to fit on then end of the store aisle's (Endcap) by Rank but Store A only has 3 places to put them so I need for the 4)TUV Riesling to move to the next appropriate are on the floor (Sidestack). Is there any way to get that done??
So for this Store A that only has the room below this is where they would go
I would have
3 Endcaps - 1)XYZ Merlot,2) ABC Chardonnay, 3)GHI Cabernet
2 Sidestacks - 4)TUV Reisling
1 Woodbox
But Store B that only has the room below this is where they would go
I would have
2 Endcaps - 1)XYZ Merlot,2) ABC Chardonnay,
2 Sidestacks - 3)GHI Cabernet 4)TUV Reisling
1 Woodbox
and so on please help new to this
Last edited by amauricio2; 03-02-2009 at 11:05 AM.
Reason: forgot something
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules