Assign a value to a field from one table to a field in another

[lcross23]

I have a Access database that I inherited, and I do not want to alter
the inital table or forms. I am adding a table and I want to insert a
new record and assign fields of that record with some data from the
first table with data from the first table in the second on a button
click. I am looking for some guidence on how to do this.

 

[Deborah Jean]

You could try an append query
http://office.microsoft.com/en-us/assistance/HA011860631033.aspx#1