Shadow Table

[captain crash]

Hello.
I would like to create a table(#2) that copies every record entered into another table(#1), whether by form or manually.
But, after the record is copied into table #2 I don't want it to have any dependencies to the original. I want to be able to change the record in table #1 without it affecting the original record that was copied into table #2.

Can this be done?

 

[pbaldy]

Welcome to the site. It can be done, but you'll need to do it. Access does not support triggers. Try the after insert event of the form used to add records, executing a query that appends the record to the second table. It sounds like you may want audit type functionality, if you want to search on that.