Consider the following scenario: I have 2 database tables, table1 and table2

create table table1 (id int, name varchar(100));
create table table2 (id int, name varchar(100), table1_id int);

I use QSqlTableModel + QTableView to display id and name from table1, and
QSqlRelationalTableModel + QTableView to display id and name from table2, and related name from table1.

How do I make QTableView showing data from table2 pick up the changes made to table1 to display updated table1.name?