Hi,
I'm using Access 2007 and I'm trying to find the best way to copy records from a read only source table into another table. The criteria would be based on a purchase order number in each table. If the record in the source table has a purchase order number that isn't in the destination table, it would be appended to the destination table. If the purchase order number exists in both the source and destination tables I would just want to update (copy) the record from the source table to the destination table. I'm assuming I need a cross between an append query and an update query but not really sure how to create it. Any help would be appreciated.