Auto Update another table if any changes happen in one table

Hi All,

how can we create trigger in MS Access and below is my scenario.

i have a Access Database file and in that i have A-Table and i make a copy of A-Table renamed as B-Table and suppose if any changes/modification anything happen in A-table then Automatically B-Table should update.

how can i achieve these, can you please guide me on these.

Note1: Deletion and New recording adding to A-Table then nothing should happen.
Note2: Table contains more than 40 fields.


i can not share my file as its contains sensitive data.

I cannot understand the need to have a duplication of a table. Perhaps, if you explain that, we can offer a different type of solution. Duplication of information is contrary to the rules of Normalization.