Actually I am defeated. I am looking for a query to show students and classes and streams.
I created sub forms like this.
Look at relationships.
Main form- tblstudents.
Subform1- frmgradeyears.
Subform 2- frmgradestream.
Now my question is
When I create a query it puts a student in all...