Need some ideas

[amauricio2]

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