Create record on amount of sku's

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

If I understand you correctly, you would need a new table which would have
the 16 records for the pallets with a unique pallet ID for each record.

Would this data need to change when the sku changes? For instance, would
you need the pallet number to start over with a new sku or would they just be
consecutive?

Let us know. I am doing something which seems similiar to this for a client
and could possibly send you an example.

Jackie


"Jurgen" wrote:

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

1. yes, created 16 records
2. After import from other database they can change the qty or cpq or boxes
on pallet and after the change it must created the records
The pallet number (autonumber) must be a unique number (the number is used
in the future for intern transport in our WMS system

Jurgen

"Jackie L" wrote:

If I understand you correctly, you would need a new table which would have
the 16 records for the pallets with a unique pallet ID for each record.

Would this data need to change when the sku changes? For instance, would
you need the pallet number to start over with a new sku or would they just be
consecutive?

Let us know. I am doing something which seems similiar to this for a client
and could possibly send you an example.

Jackie


"Jurgen" wrote:

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