I do have two kind of crates (1 large, 1 small) to be delivered to x locations (one crate per location). Into each crate I should be able to fit any combination of 7 different sized boxes. FM should know, when one crate is full.
Each box contains specific amounts of products (I have data, how much fits in one box), restricted by the maximum that one box can hold. How do I start out, to find the optimal packing of these boxes, given that the combined boxes in a crate make "the product" to be delivered.
This is basically food delivery and distribution within one city. The client already works with Filemaker and wishes to stay with it. Where do I start?