I have database where 3 tables
1st table "Departements"(departemenetcode-autonumber,departementname)
2nd table "Teachrs"(teachercode-autonumber,teachername)
3rd table "Students"(studentcode-autonumber,studentname and other information for student)
In "Teachers" table I have combo based on Departementscode and Departementsname.
In "Students" table I have 2 combos.First based on Departements,second based on Teachers,and comboteachers is depended from combodepartements,when I select value from combodepartements only teachers of that Departement are shown in comboteachers.
I want to have form where I will have combodepartement,comboteacher that is depended from combodepartement and has "all" selection in it,combostudent that is depended from comboteacher and has "all" selection in it.When I select Departement name in combo I want to see this Departement's teachers and "all" selection in comboteacher and the same in combostudent.When I press "Run Query" button on my form I want to see filtered records for my selections in combos. I ll be very glad if you help
To answer please click on Q or A sign on the left of the subject.
Written and designed by
Send us your comments
Copyright © 1998-2007 by MAUG