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

(Jason F) #1

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) #2

Not possible within the app itself.

(Philip Garrett) #3

@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.