Duplicate a record in another table

S

Sharon A

I have a table in which records need to be updated on an ongoing basis,
however I could also do with keeping track of the amendments. I have been
considering whether to create another table and have some form of update so
when a specific event takes place it can keep a permanent copy of this
record, but the records can be modified in the original table.

Is this possible or is there an alternative way to track changes.

Thanks
 
D

DevalilaJohn

Have you considered putting a date/time field on each record in the original
table. Then whenever a record is added or changed, record when and run your
updates based on that.
 
S

Sharon A

I could do that, but it's the updating to another table from the form I'm
looking at that I'm not sure how to do. Is there a process I can set up that
will copy part of the record over if the user click on a button on the form?
 
Top