I am trying to figure out the easiest way to copy values from one table to another. I have two tables in an ms access database: Hardware and Archive
\r\nRight now, when Hardware is returned from a shipment, the transaction number is set to "0" to indicate the item is back in stock. Before that takes place, I would like to write the transaction number (transaction_no) and the hardware id (key_id) to the archive table as a cross reference so users can see what hardware was associated with which transaction.
\r\nIs there a way to select the transaction_no and key_id from Hardware and write those values to fields with the same names in the Archive table?
\r\nI have been trying to find an example somewhere. I can\'t believe I am the only person ever to have this problem
\r\nThanks in advance for any help