How can I copy all rows of data for a specifi...

[Jason_F]

How can I copy all rows of data for a specific Order Number like Products, QTY and Price to a new table after we ship the item so I can maintain the Inventory Quantity?

Using Actions or Form?!

From tblSales ORDERNUMBER .ITEM

.

QTY .

PRICE 111111111111 .

Apple

.

3

.

$10 111111111111 .

Orange

.

5

.

$16

To tblInvoice INVOICENUMBER .ITEM

.

QTY .

PRICE 222222222222 .

Apple

.

3

.

$10 222222222222 .

Orange

.

5

.

$16