what u can do:-
1- is join two tables by "update" so if one is updated the other one will be updates as well.
2-Create Query which will update the data in desired tables.
3-Approach Directly through ADO/DAO.
there could be other solutions as well...but those are the ones i can think of..
hope this helps.bye