I have a database with 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
> 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
