Student Progress Database Application

Ok, there may be a issue of terms here. When I talk of the grade, I am referring to the score earned by the student for that course for that period. In your table it is called Grade. But it can be called score, marks, or whatever. You referred earlier to "in Mathematics scores 72/100", so this would be the 72.. If the field in the table named Grade is not for this value, then add a field for it and add a control bound to it. 

And by the way, we use grade in both ways. It could refer to a score on a test or for a course or it could refer to a level of education. 

Now, you can pre-populate all the records if you want. What you want to do is create a query that returns all the student in a Center. Add the Course table without a join. This should give a listing of all the students with one record per course (so each student would have 4 records.) You would then add a column for the month and turn it into an Append query. When you run that query it should add a record so you can enter the marks.

Okay, I just can't seem to wrap my head around this thinking of storing records in tables and not in fields. I think I'm confused now. What I have on the second sub form are 4 controls wiz. CenterCode, StudentID, CourseID and GradeMonth. And you say lets have a fourth control for the grade. Let me clarify in my country a Grade is supposed to be a class or standard in which a student is enrolled in. In your country a grade is different. I just told you this for information sake. Now, my confusion remains as I cannot see which control on the second sub form will be used for allotting marks for each student?

Also, I do not want to show records for one student at a time, I want the second sub form to populate with the names of all students belonging to the particular CenterCode chosen from the main form combo box then I can enter the marks for each student according to their StudeintID's.

Now, I need to know do I make 4 text boxes on the second sub form for each student in the continuous form in tabular view to store the marks for each student? But the question is which field will store these marks in their respective subjects?

You keep missing the point here. Once more. 

The attributes of a grade are the Student who received the grade, the course the grade was for, the period the grade covers and the grade itself. So you have a RECORD in a table with those attributes. So each grade is a RECORD in a table. NOT a field. So if there are 4 courses they received a grade for, then there will be four records for that student for that period.  So your second subform is already set except that it needs a control for the grade. 

Now, if you want to ONLY show the records for one student at a time, that can be done. What can aso be done is to pre-populate the table for all the courses.  But you have to stop thinking of the grades as fields in a table for each course.

Hi,

Thank you for the quick reply. Yeah, you're right there is actually no need for the first subform, but then, it provides a visual representation to the user to avoid mistakes when filling out the marks for the student.

Okay, now, each student has to go tests in 4 subjects or courses each month. Each subject or course (there are 4 of them wiz. Hindi, English, Mathematics and Science) is of 100 marks maximum making a total of 100 x 4 = 400 marks total for each student. So, for example, in English a student scores 55/100, in Mathematics scores 72/100, in Hindi 45/100 and in Science 89/100. The report should show the total of each subject the student got in the month and then calculate a percentage aggregate for each student.

Now, I need to know do I make 4 text boxes on the second sub form for each student in the continuous form in tabular view to store the marks for each student? But the question is which field will store these marks in their respective subjects?

OK, first, I don't really see the need for the first subform, but it does no harm to be able to view a list of students for the selected Center. 

However, editing the Recordsources is not the way to go. As long as you set the The Linked fields properly for each Subform, then they should reflect the Selected record on the main form. did you use the subform wizard to embed the subforms? Did you select the Centercode as the linking fields?

As for entering the grades, You do thay in the second subform. You should have a combobox to select the Student, you already have a combo to select the course and month. Now you just need a textbox to enter the grade. 

I'm still not clear, is it 100 marks for the period spread out over each course?