title: MS Access: Save form data to 2 tables at the click of a button
body: <p>I am creating an asset management database with 2 tables (Assets and AssetMovements) and one form (Assets). 
  I need to keep records of every asset movement, so every time a new asset is added to the Assets table or the 'Location' value for an existing asset record is modified, the record should be saved to the AssetMovements table. The AssetMovements table is just there to record the transactions.</p>
  
  <p>How can I achieve this? I would be grateful for any pointers I can get, or if anyone can suggest a better method of keeping the movement records.
  Thank you.</p>