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

[Steven_Coile]

Not possible within the app itself.

[Phil]

@Jason_F

Have you considered leaving the rows in place and adding a “Status” field that indicates whether the item has shipped. That would allow you to keep the rows around for inventory purposes but recognize that they have been shipped.

You have probably already considered this, but I mention it just in case.