albertotactik
Member
Let's see if you can give me an enlightening view…
I have created 3 tables
"Student" table
Name + last name
"Emateria" table
asignatura
"Evaluate" table
Note 1 + Note2 + Media
Idalumno (FK)
Idmateria(FK)
I have created 2 foreign keys in table "evalua"
Idalumno, Idmateria
I would like that when displaying list "evaluate"
The students in the “student” table will be displayed
And the subjects of the “emateria” table will be displayed
And I could manually add the fields note1 + note2 + average
I tried to make a list join… and I can't see the data in the evaluate table.
Attached image, to make it clearer.
In summary:
Add first and last name in table "student"
I add subjects in the “emateria” table
And I would like to display in the table "evalua2"
I'm doing something wrong ... and I can't figure it out.
If you need any more information… I'll upload it right away…
Let's see if I can get it…
Thank you for your time and sorry for my bad English ...
I have created 3 tables
"Student" table
Name + last name
"Emateria" table
asignatura
"Evaluate" table
Note 1 + Note2 + Media
Idalumno (FK)
Idmateria(FK)
I have created 2 foreign keys in table "evalua"
Idalumno, Idmateria
I would like that when displaying list "evaluate"
The students in the “student” table will be displayed
And the subjects of the “emateria” table will be displayed
And I could manually add the fields note1 + note2 + average
I tried to make a list join… and I can't see the data in the evaluate table.
Attached image, to make it clearer.
In summary:
Add first and last name in table "student"
I add subjects in the “emateria” table
And I would like to display in the table "evalua2"
I'm doing something wrong ... and I can't figure it out.
If you need any more information… I'll upload it right away…
Let's see if I can get it…
Thank you for your time and sorry for my bad English ...