Good day I am designing a database that would be used to track student grades throughout their academic life. Hence I have the following tables grade, student , class , teacher and course. For the grade table I am using a composite key which is defined as Student ID (text) Course ID (text) Term ID (text). I designed a form with cascading combo boxes so that when I select a class the coresponding student names comes up due to the number of students that I am trying to keep track of. What I need the form to do is to allow me to select a student name , write to the grades table as Student ID, from there i can select a course , select a term and enter the corresponding marks . I have been thinking about it and I came up with 2 theoretical options
1) write a SQL trigger that forces the database to write the value to that table (not sure how to do this) or
2) create a marco that calls the value and write it to the grade table.
Can anyone offer me some more ideas on how I can solve this problem or a possible solution for this problem. Thanks in advance
1) write a SQL trigger that forces the database to write the value to that table (not sure how to do this) or
2) create a marco that calls the value and write it to the grade table.
Can anyone offer me some more ideas on how I can solve this problem or a possible solution for this problem. Thanks in advance
Last edited:
