hi guyz.
I need your help in making a query or code for following problem;
I am making a database of a warehouse where product is placed on specific locations. I receive the stock as dead pile (in bulk) then my team palletize the whole stock and put away the stock to specific locations. when the stock is received, a document is generated where the detail of the stock is mentioned.For example i have received 520 cartons of ice cream. On pallets every product type has different stacking pattern, suppose 50 cartons of ice cream are placed on 1 pallet, then there will be 10 pallets of 50 cartons each and one pallet of 20 cartons.
now what i am trying to do is, i have a main form and a subform, on main form i input information in 3 fields
1. Product (text) : Ice Cream
2: Qty rcvd (number): 220 (cartons)
3: Pattern (number): 50
i need an append query that fill down the subform as below;
pallet # product quantity
1 ice cream 50
2 ice cream 50
3 ice cream 50
4 ice cream 50
5 ice cream 20
Simply i just want to distribute bulk quantity into pattern pieces and the last position will have remaining. I guess some coding will be required,
where i am failing.
appreciate ur help.
regards