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.
I'd love some advice or help!