Using the Database Explorer, I can add records to a table from another table with the same structure using the Add method. I can select the Append and Update option and the target table will update any existing records and append any new records in their proper position. My question is, how do I do this in Delphi at runtime? What are the methods or procedures? If this particular method doesn't exist, how would I do this using a Query?