Create an append query that gets the fields from the original record and
appends it to the second table, then create a macro that runs this query and
call it from the onclick event in your form's button, I recommend you have a
primary key on the original record for easier reference when appending the
information to the other table,