Duplicate a record in another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Records in Current Table and another Table 5
Yet another duplicate record dilemma 7
Expiration Date Automatic Update 1
Duplicate Records - Can't Locate Source 1
Record-Locking remains open after closing 0
Same record/Primary key in multiple tables 0
Searching Across Two Tables For A Record 3
Table cleanup 3

Back
Top