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 append records to the table tblPurchaseOrders from the table tblTempPurchaseOrdersImport ONLY when two field values from tblTempPurchaseOrdersImport do not already exist in tblPurchaseOrders. Those two field names are PurchaseOrderNumber and PurchaseOrderLineNumber. When they do not exist I want records from the tblTempPurchaseOrdersImport to be ADDED to tblPurchaseOrders . How can this be done.
I'm sorry if this is confusing.