AnsweredAssumed Answered

Looking for some advice

Question asked by user28631 on Jun 11, 2017
Latest reply on Jun 12, 2017 by wimdecorte

struggling with a project here, not sure how to solve it.

 

I have 7 parts, each part can be boxed in several boxes, but not all boxes.  Example:

 

part 1 can go in Boxes A, B, F

part 2 can go in Boxes A, D, E

part 3 can go in Boxes D, J

and so on.

 

once a box is used, it's consumed for the day.

 

each also has a due date.

 

client wants the database to loop through all options and combinations to find fastest combo, among two thousand of these.  They also want the ability to insert emergency orders and have the rest of it adjust.

 

possible?

 

I'd love some advice or help!

Outcomes