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 Cursos(
ID_curso int not null auto_increment,
Nome_curso varchar (50),
primary key (ID_curso)
)default charset = utf8;
And one table called Cadastrados:
To copy to clipboard, switch view to plain text mode
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;
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;
To copy to clipboard, switch view to plain text mode
Using QT, I was able to list all Cursos.Nome_curso with comboBox:
ui->setupUi(this);
model->setQuery("select nome_curso from Cursos");
ui->comboBox->setModel(model);
ui->setupUi(this);
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("select nome_curso from Cursos");
ui->comboBox->setModel(model);
To copy to clipboard, switch view to plain text mode
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
Bookmarks