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?

Couple of problems. You state that you "should be able" to fit "any combination." Unless there is something you can relate to all of the boxes (e.g. cubic inches), it's going to be difficult to programmatically attack the challenge. Using the largest box, can you still get seven boxes in a crate? If so, then the problem is fairly simple. Count the number of boxes and cap that at seven. But I'm going to guess it isn't that simple. Is the seven box limit required?

I think I would approach it by establishing a volume number for each box size. Then you can figure out what the capacity is for the crates, then have the box size added to the crate until FM reports that the crate is full.

The other question is the delivery process. Does the crate have to be full before it can be delivered?

It certainly sounds doable, it's just a matter of picking your approach.

HTH