Well I started over and decided that I need a complete table and using an append query to add records to it based on teacher and date. Then if it doesn't exist I build a new list and append it then display the appended data in the subform.
MAN I SUCK AT SQL but I got it working.
thanks for the...
I have done this as well as a lot of other tries at this but I still run into the same problem..I guess I can't see the forest for the trees.
If I have a subform that is linked to tblstudents
tblstudents has "student name" in it that is a subset of students by teacher.
BUT "date" "start time"...
Ok access noob here and a first post as well...
I have to filter a table that has children and teachers.
I made a form with a combo box of teacher names then filtered
on the teacher name.
in the subform I have to create a matrix of the children that
are assigned to that teacher.
it would be...