I have two tables. One of them is a temporary table named tblTempPurchaseOrdersImport and the other one is named tblPurchaseOrders. I'm trying to figure out how to REPLACE records in the table tblPurchaseOrders from the table tblTempPurchaseOrdersImport ONLY when two field values from tblTempPurchaseOrdersImport DO already exist in tblPurchaseOrders. Those two field names are PurchaseOrderNumber and PurchaseOrderLineNumber. When they DO exist I want records from the tblTempPurchaseOrdersImport to REPLACE the records in tblPurchaseOrders . How can this be done.
I'm sorry if this is confusing.
(I just posted a similar topic but just the opposite from this scenario)