J
Jurgen
Can anyone help me how to tackle this.
example:
- We receive a container with Sku's, 10000 of sku X
- There are 20 pieces in a box (cpq)
- and there are 30 boxes on a pallet
that means (10000/20)/30 = 16 whole pallets
Import table from other Database (DB2): Sku, Cpq, Pcfg(boxes on pallet),
received Qty
I need to copy the pallets to a another table to give it a unique number
(pallet Number), autonumber?
How can i do this, i have no knowledge of VBA can anyone give me a push in
the right direction (like we say in dutch)
Thank you
Jurgen
example:
- We receive a container with Sku's, 10000 of sku X
- There are 20 pieces in a box (cpq)
- and there are 30 boxes on a pallet
that means (10000/20)/30 = 16 whole pallets
Import table from other Database (DB2): Sku, Cpq, Pcfg(boxes on pallet),
received Qty
I need to copy the pallets to a another table to give it a unique number
(pallet Number), autonumber?
How can i do this, i have no knowledge of VBA can anyone give me a push in
the right direction (like we say in dutch)
Thank you
Jurgen