Use currenttext comboBox for query

[DalPai]

Hello,

In my database I have a table called:


create table Cursos(
ID_curso int not null auto_increment,
Nome_curso varchar (50),
primary key (ID_curso)
)default charset = utf8;

And one table called Cadastrados:


create table Cadastrados(
Nome varchar(50),
Matricula varchar(9) unique,
Curso_id int not null,
primary key (Matricula),
foreign key (Curso_id) references Cursos (ID_Curso)
)default charset = utf8;

Using QT, I was able to list all Cursos.Nome_curso with comboBox:


ui->setupUi(this);
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("select nome_curso from Cursos");
ui->comboBox->setModel(model);

But now I want to select one Nome_Curso of the combobox, and list all the Cadastrados of that respective curso (TableView, maybe?).

But I have no idea where to start. Any help?

Best regards,
DalPai

[Lesiok]

To display the data from the second table You need a Cursos.id_curso and not Cursos.Nome_curso. So the model query should be "select nome_curso, id_curso frim Cursos". Try think the rest yourself :)