Student Progress Database Application

Okay, I've tried to create sub forms and quires according to your guidelines. The first sub-form's recordsource is only tblStudents.

The Second sub-form is where the tblStudentProgress. Both these 2 forms are filtered by CenterCode by the automatic link between them.

After this I created a query based on tblStudentProgress and tblCourse. Both these 2 sub-forms are filtered on the CenterCode selected from the combo box on the main form.

Here's the SQL of the query:

SELECT tblStudentProgress.CenterCode, tblStudentProgress.StudentID, tblStudentProgress.CourseID, tblStudentProgress.Grade, tblStudentProgress.GradeMonth, tblCourse.CourseName, tblCourse.CourseScore

FROM tblCourse INNER JOIN tblStudentProgress ON tblCourse.CourseID = tblStudentProgress.CourseID;

Now when I select a centercode from the combo box, the first sub-form filters the students from the center. I can now enter 4 records for each StudentID by just pressing the tab key and moving on to the next StudentID. Also I can select the grade month and CourseID. You also mentioned an append query.

Please explain the process of creating an append query once again.

Thank you.

Ok the first subform is the student listing, correct? That should only be:

SELECT tblStudents.CenterCode, tblStudents.StudentID, tblStudents.StudentName, tblStudents.StudentGender, tblStudents.DOB FROM tblStudents;

In fact, the Recordsource need only be tblStudents.

The Second subform is where the grades should be and that should be just tblStudentProgress. No need for a SQL statement.  I said before that the filtering by Centercode is a function of the link between the Main form and subform, nothing else. 

But this is not what I asked for. I told you to create a query that includes tblStudentProgress and tblCourse. Filter that query for a specific CenterCode. That query should return a record for each student for each course. So if there are 4 courses, then there should be 4 records per student.

Okay, first things first, straight off, here's the SQL from the first sun form:

SELECT tblStudents.CenterCode, tblStudents.StudentID, tblStudents.StudentName, tblStudentProgress.Grade, tblStudents.StudentGender, tblStudents.DOB

FROM tblStudents LEFT JOIN (tblCenterDetails RIGHT JOIN tblStudentProgress ON tblCenterDetails.CenterCode = tblStudentProgress.CenterCode) ON tblStudents.StudentID = tblStudentProgress.StudentID;

The second sub form has the following SQL :SELECT tblStudents.CenterCode, tblStudents.StudentID, tblStudentProgress.CourseID, tblStudentProgress.Grade, tblStudentProgress.GradeMonth, tblCourse.CourseName

FROM tblStudents LEFT JOIN (tblCourse RIGHT JOIN tblStudentProgress ON tblCourse.CourseID = tblStudentProgress.CourseID) ON tblStudents.StudentID = tblStudentProgress.StudentID

WHERE (((tblStudents.CenterCode)=[Forms]![Production_CenterDetails_Main_Form]![Combo15]));

The above is the SQL for the 2 different sub forms. If these 2 are right, only then I would like to proceed further.

I'm adamant to learn and persevere through the process. Yes, your're right, I am inexperienced and a novice, but nobody ever came from above learning about everything there is to know., Everyone has learned the way I am learning now. But then, if I have experts like you around, I am determined to be guided by you and finish the application no matter how long it takes for me to get there. Let me go through what you just instructed and then I'll get back to you.

Ok, That paragraph outlines what needs to be done. It tells you that an Append query would be used to populate the table. 

To add the table without a join, just Add it from the table pane but don't join it to the student table. Like I said this is a step by step process and you should be concentrating on getting the first step right before thinking about the next steps. Once you get the first step right the next steps will become clearer. The first step is creating a query that returns a record for each student in the center for each course. Have you done that? If not what is not working? Show me the SQL.

"This is taking more time than I expected. "

Then your expectations were off. Developing an Access database is not a simple task, especially for the novice. There is a pretty steep learning curve for Access.  While an experienced developer could churn out your app in a couple of days, it may take weeks for the inexperienced.