trying to add data to a filtered list

[Whopper]

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 something like this

teacher date child name start end


the teacher and child name are in tblmain

the date start and end values have to be in tbldata1

so the beginning they want to choose a teacher and a date
so I shifted and put the teacher in a combo box and tied it to nothing
but the subform
so combo box teacher and field date
links to subform are teacher;date

combo box(teacher name)==> Ms. Eve text box(date)==> 01/01/06

but they want a filtered list on teacher so the subform would have to be

teacher date child name start end
Ms. Eve 01/01/06 mary lamb
Ms. Eve 01/01/06 billy bull
Ms. Eve 01/01/06 bob jones


then they could put in start and end for each child

I don't see how I can get the child names filtered thru a query (this
I can do) BUT then to be able to edit the fields and put this data
into a new table.

IS there a way to do this?


a big help for any ideas or pointers as I am lost on this

 

[battenberg]

looks like the underlying problem is your tables...

open a new database and try the following:

Create new tables: tblTeachers & tblChildren
link many children to single teacher,

you should then be able to create a 'teachers form' then add a 'children sub form' to create your matrix and filters.

 

[Whopper]

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" "end time" are tied to a table that must keep the daily inputs..

(displayed from filter) new table------------------------
student name date start time end time

I don't think there is a way to list student name filtered by teacher and then have "date" "start time" "end time" that is tied to a table as well.

its like saying a query and a table tied to a single form and that can't be done can it?

 

[Whopper]

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 tips