Hi!
I'm using QSqlRelationalTableModel to get information from two related tables. The image shows the view used to manage data.
question.png

This is the code for the model and the view:
Qt Code:
  1. QSqlRelationalTableModel* pessoaDialog::setupModel()
  2. {
  3. QSqlRelationalTableModel *model = new QSqlRelationalTableModel(this, QSqlDatabase::database("connection1"));
  4. model->setTable("pessoa");
  5. model->setRelation(model->fieldIndex("Pessoa_idLocalidade"), QSqlRelation("localidade", "idLocalidade", "nomeLocalidade"));
  6. model->setRelation(model->fieldIndex("Pessoa_idHobby"), QSqlRelation("hobby", "idHobby", "nomeHobby"));
  7. model->setEditStrategy(QSqlRelationalTableModel::OnFieldChange);
  8. model->setHeaderData(0, Qt::Horizontal, "Id");
  9. model->setHeaderData(1, Qt::Horizontal, "Nome");
  10. model->setHeaderData(2, Qt::Horizontal, "Localidade");
  11. model->select();
  12. return model;
  13. }
To copy to clipboard, switch view to plain text mode 

Qt Code:
  1. QTableView* pessoaDialog::setupView()
  2. {
  3. view = ui->tableView;
  4. view->setModel(model);
  5. view->setItemDelegateForColumn(2, new QSqlRelationalDelegate(view));
  6. view->setItemDelegateForColumn(3, new QSqlRelationalDelegate(view));
  7. view->horizontalHeader()->setSectionsMovable(true);
  8. return view;
  9. }
To copy to clipboard, switch view to plain text mode 

When i'm inserting data (see the attached image), the view shows the the PK value(idLocalidade or idHobby) instaed of the related info (nomeLocalidade or nomeHobby).
As soon as i submit the data, it is shown correctly!
How can i change this?

Thanks

The EER Diagram:
eerdiagram.png