Use currenttext comboBox for query
Hello,
In my database I have a table called:
Code:
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:
Code:
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:
Code:
ui->setupUi(this);
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
Re: Use currenttext comboBox for query
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 :)