[Solved] Mapping a column from a table to a QComboBox
I have a table in a database and I want a column’s content be shown in a QComboBox.
I’ve seen examples using a QDataWidgetMapper for this but there is another table.
I’ve thought creating another table and create a relation with a foreign key and then to follow the strategy in sql examples for mapping
the column to QComboBox.
Is there a way for mapping the content of a table’s column to a QComboBox without creating another table?
if you want to map in this combo box the column of an external table, your model must be a QSqlRelationalTableModel, you have to set relations properly (see the docs) then you can get the external table with
- yourModel=modelToMap->relationModel(<foreing key column>);
I didn’t made it. I did like that and doesn’t work:
- model = new QSqlRelationalTableModel(this);
- proxyModel = new QSortFilterProxyModel;