automatically filtering data in forms

[lepsid]

Hello!
I have one problem with "filtering" data.
I have created three tables: 1. schools 2. teachers and 3. activities.

In school table, there are fields "school name", "city".
In "Teacher" table I created fields "teacher name" and "teacher school". "Teacher school" is look up field which reads the data from "school name" field in "school" table.
In activities table, I have created fields "name of activity", "participated schools" and "participated teachers". What I am trying to set up in the form is to automatically filter the teachers names from selected school. For example. I have schools A and B. There are three teachers in school A, and their names are A1, A2 and A3. In school B, there are teachers B1, B2 and B3. In activity table form, I need to chose which school participated in activity. So, I choose from dropdown list "school A". In the following field "participated teachers" which is also dropdown list of teachers, I want to see listed only teachers from School A, but don't want to see listed all the teachers (including school B). Is it possible to do in Access and how.



Thank you for your help.

[ItsMe]

Before you can "Filter" results you need to build a query using the proper relationships between the tables.

[uk123]

for combo filter.. how to do.. pl see http://support.microsoft.com/default...en-us%3B209576 .. implement the same in your DB

[orange]

Review Cascading Comboboxes.
see http://www.datapigtechnologies.com/f...combobox2.html