Counting record based on a criteria
Hello! I have two tables: Classes and Students. Classes fields: Class Name, Teacher, and Start Date Students fields: Name, Class Name, and Start Date Someone will enter records in the Classes ...
Forum Discussion
My suggestion is to change the structure of your app.
It should be set up like
One Course Master has Many Scheduled Courses.
The Course Master is like the catalogue of the course content.
The Scheduled Course is saying that say Economics 101 will be run in the Fall 2018 semester.
Then One Scheduled Class will have many Student Class Registrations.
One Student will have Many Student Class Registrations.
It should be set up like
One Course Master has Many Scheduled Courses.
The Course Master is like the catalogue of the course content.
The Scheduled Course is saying that say Economics 101 will be run in the Fall 2018 semester.
Then One Scheduled Class will have many Student Class Registrations.
One Student will have Many Student Class Registrations.
There are 4 tables.
1. Course Master
2. Scheduled Courses
3. Students
4. Student Class Registrations
1. Course Master
2. Scheduled Courses
3. Students
4. Student Class Registrations
