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
User | Count |
---|---|
31 | |
14 | |
3 | |
3 | |
2 |