Hello Expert, I am building a simple database entry where teachers could entry student grades based on their subjects. Here's the problem I run into I am at cross-roads of how to go about it: tblStudent contains basic info plus grades,semesters etc and student's corresponding subject tables for that SEMESTER: tblEnglish, tblScience, tblManagement, tblAccounting etc. I've structured tblEnglish to have following fields ID, StuID, tutorials, journal, report, speaking
Questions: How do I relate them all the subject table to student table? I've tried everything from building relationships to query, nothing works.<br><br>What I want to achieve is, teachers are able to see ALL the student Names like excel datasheet WHO have taken their class and able to put in their corresponding grades in that field (tutorials, journal report, speaking).
Please help, how do I achieve this.