B
Bernie
I am working on a database design for a school's grading system and here is
an overview of my database. There are three tables that need to be of
concern. The first table is the one that holds the primary key field
‘StudentID’ along with their address and everything else is just called
"Students". The second table that holds the class name description and
department ID is called "tblKinDescriptions." And the third is called
"tblkinGrades" which holds the grades for semesters 1, 2, 3, and 4 and a
StudentID field. The tables "Students" and "tblkinGrades" are related by a
field called "StudentID". Besides from the tables there are two forms
"frm1stStudent" which is a main form and "the newest subform", which is a
subform which in “frm1stSudentâ€. The “frm1stStudent†displays the student's
information from the table "Students" and "the newest subform" displays
information between the two tables "tblkinDescriptions" and "tblkinGrades".
Now here is my dillema and what I'm trying to do: Keep the fields from
"tblkinDescription" to be static for every "Student ID" new and already
created but the fields from "tblkinGrades" should just be zero's able to be
updated for each "Student ID".
Is there any way for this to be done, perhaps through code or something?
Any input is much appreciated.
Thanks
Bernie
an overview of my database. There are three tables that need to be of
concern. The first table is the one that holds the primary key field
‘StudentID’ along with their address and everything else is just called
"Students". The second table that holds the class name description and
department ID is called "tblKinDescriptions." And the third is called
"tblkinGrades" which holds the grades for semesters 1, 2, 3, and 4 and a
StudentID field. The tables "Students" and "tblkinGrades" are related by a
field called "StudentID". Besides from the tables there are two forms
"frm1stStudent" which is a main form and "the newest subform", which is a
subform which in “frm1stSudentâ€. The “frm1stStudent†displays the student's
information from the table "Students" and "the newest subform" displays
information between the two tables "tblkinDescriptions" and "tblkinGrades".
Now here is my dillema and what I'm trying to do: Keep the fields from
"tblkinDescription" to be static for every "Student ID" new and already
created but the fields from "tblkinGrades" should just be zero's able to be
updated for each "Student ID".
Is there any way for this to be done, perhaps through code or something?
Any input is much appreciated.
Thanks
Bernie