title: Need to insert new rows into a different table when a form updates
body: <p>I'm working in a database (which I didn't design) and I'm running into a problem I can't solve. The database is used to report on productivity metrics for accountants at a property management company (ex. if the manager runs the report for 5/1/14, it returns the list of properties that each staff accountant was assigned as of that day) as well as what the assigned points (1 point for cash-based accounting, but 2 points for accrual-based accounting, etc.) were for each property.  </p>
  
  <p>Now my boss would like to be able to archive the points values for each property so that when the reports are run, they report on whatever the values were on that particular day, even if the values for the property have since changed.  </p>
  
  <p>The first problem I've run into is that most of the database is dependent on the property's ID number (this is used company-wide) being the primary key so I had to create a new "archive" table with the primary key being an auto number so that a property can have multiple rows of data.</p>
  
  <p>Property values are updated in a form. When the form is updated, I need the original table to be updated with the new values (this is what happens now) but also for a new row to be inserted into the "archive" table with the all of the form's data. Then, I'll just have to re-do the report queries to direct to the archive table and add another date filter.  </p>
  
  <p>Does anyone how I can make this insert/copy thing happen?</p>
  
  <p>Thank you so much!</p>