Hi,
You need to process on some event. Without any event your database table data will not be updated. So first you need to decide when you need to update two table of your database.
Secondly you can use update query to update table. Or you can use stored procedure to update tables.
Check
this thread[
^] to check update query to update multiple table with single query.
Hope this information will help you.