modification of record

[dharkin]

Hello,

Can anyone tell me how to allow a record to be created and after it is created to modify it only. I am trying to create a school grading program. I have a student table then my classes, and teacher table.

When a student is selected and a grade is entered in say language arts first quarter a teacher can then go back into a the database and enter a grade(record) for the same student and class. thus creating two grades for the same student and class. so I would like this just to be modified after the grade is created. My only other alternative is to create a flat database which I really do not want to do. Maybe my design is way off any help would be appreciated. I have an import file of students as my starting point from our main student info system.

Thanks in advance

[mr_vodka]

I think you might need another table here to join some of these other tables together.

You should have a year table that has the Q1, Q2, Q3, Q4 etc. This table should have relationships to the student and subjects table.

You can have it so that you can select a year for each student. Then the year will have certain subjects (teachers realted to subjects) for that particular year. A grade can be entered for each student, for each class, per each quarter in a selected year.

[dharkin]

so maybe

students, teachers, classes, and grades?

Perhaps a seperate table for each class with the ability to grade within that table for instance:

table for language arts with the 6 grading standards included

for quarter 1 then a table for language arts with the 6 grading tables for Q2?

Am I thinking right?

thanks for the response

[mr_vodka]

This is a very crude mock up file. Take a look for some ideas.

teachers.zip

[dharkin]

Thank you very much for taking the time

to help me I will take a look at your solution.

I will probably have a few more questions I hope you would not mind checking back on this forum