T
Telesphore
In the table of the students [tblStudents] of our school containing the
fields of the identification of the students, we had fields concerning the
diplomas obtained.
To reduce the table of the students, we decided to create a new table
[tblDiplomas] with the fields which existed in the table of the students.
However probably for a problem of relations between the old one and the new
table, by adding a new student in the table of the students, we realized
that it did not have his equivalent in the table of the diplomas:
tblStudents = 663 students, tblDiplomas = 662.
tblStudents with the primary key StudentID, plus the fields Name, Street,
City, etc.
tblDiplomas with the primary key DiplomaID, plus the fields StudentID,
Number, Note, Mention, etc.
It has a relation One-to-many with the application of the referential
integrity between the primary key StudentID of tblStudents and the StudentID
field of the tblDiplomas.
Thank you for any suggestion.
fields of the identification of the students, we had fields concerning the
diplomas obtained.
To reduce the table of the students, we decided to create a new table
[tblDiplomas] with the fields which existed in the table of the students.
However probably for a problem of relations between the old one and the new
table, by adding a new student in the table of the students, we realized
that it did not have his equivalent in the table of the diplomas:
tblStudents = 663 students, tblDiplomas = 662.
tblStudents with the primary key StudentID, plus the fields Name, Street,
City, etc.
tblDiplomas with the primary key DiplomaID, plus the fields StudentID,
Number, Note, Mention, etc.
It has a relation One-to-many with the application of the referential
integrity between the primary key StudentID of tblStudents and the StudentID
field of the tblDiplomas.
Thank you for any suggestion.