adding data entered to a different table

[dawn]

I have a form and keeps track of employee transactions.
Each transaction/line has 15 fields. After a transaction
is completed I would like to update another table with 4
of the fields.

I know I will need to use the AddNew method to add the
fields to the 2nd table but I am not getting the syntax
right.

Any suggestions?

Thanks