Solved Yearss

[Mercy Mercy]

Can we see your modified version?

There are still things wrong which need to be resolved.

True. There is a problem with tblTeachers it says "related record in tbl teachers."
Just seeking advice.
What if I create a junction between tblTeachers and tbltermsubjects and also another junction between tblstudents and tblTeachers and tblDormitories.

Please advise.

Thanks in advance.

 

[mike60smart]

True. There is a problem with tblTeachers it says "related record in tbl teachers."
Just seeking advice.
What if I create a junction between tblTeachers and tbltermsubjects and also another junction between tblstudents and tblTeachers and tblDormitories.

Please advise.

Thanks in advance.

Upload the database so we can see

 

[Mercy Mercy]

Upload the database so we can see

I am using your improved database @mike60smart as advised by @Pat Hartman

 

[Mercy Mercy]

Junction tables are NOT optional. They are used whenever you have a many-many relationship. Can you have multiple teachers teaching the same subject during the same term? Yes, but I didn't see that as a possiblity given your last schema. Students do not have a direct relationship to teachers. Students relate to a class via a junction table and the class relates to a teacher. Students only live in ONE dormitory at a time so again, this is NOT a m-m relationship.

Relationships are not ARBITRARY. They model real life. They are what they are and if you use the wrong schema to represent them, you will not be representing reality.

Thanks @Pat Hartman

 

[Mercy Mercy]

This is Pats database modified slightly to allow the following:

1. Select a specific Year
2. Select a specific Term
3. Select a specific Grade / Stream
4. Allows the display of a Number of Students for the Grade/Stream selected
5. On selection of a Student be able to specify the Subject and then add all relevant Weeks, Exam Types & Marks.

I would imagine there are errors.

This database works very fine. However, I want to create a main form from tblstudents and subforms being
1. frmStreamStudentssubform.
2. frmTermStreamssubform.
3. frmTermSubjectssubform.
4. frmSubjectExamWeekssubform.

Thanks in advance

 

[mike60smart]

Well I think you should be able to work this out from the examples given

 

[Mercy Mercy]

Well I think you should be able to work this out from the examples given

Okay.
Thanks