You may be misunderstanding how relational databases work.
Updating Table1 is not supposed to have any affect on Table2.
If you're inserting a new record in Table1 and have data for Table2 relevant
to that Name, you have to explicitly insert to Table2 as well.
If you're changing something in Table1 for a particular Name, it shouldn't
make any difference to what's in Table2. If it does, then your database
likely hasn't been properly normalized.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> If I have two tables like this :
>
[quoted text clipped - 27 lines]
> Thanks
> Jane