Originally Posted by
nick404
So if I am understanding this correctly:
You have a pallet of 2500 products, and they are distributed into boxes of 100 products each box. So there are 25 boxes of product per pallet.
Does each box of 100 items have a specific, unique product ID? Is each pallet given a unique number/identifier?
What is the databases job? Is it to keep track of (per each pallet) how many products have been sorted into a box of 100?
Can you show us/attach what you have started already? (remove any private data, compact & repair db and zip file).