Filter into a subform

[Obeide115654]

Hi I have four tables that all enter information into a fifth table. My
tables are 'Trainees', 'Subject', 'School', 'Mentor' and they feed into
'Placements'. The 'Placements' table I have set up as a subform on the form
'Schools' and the form 'Trainees'

One trainee studies one subject per year. Each trainee has a placement at a
different school each term. Each school has a mentor for each subject. In
the placements subform on the schools table I have a dropdown list for each
of the following: a trainee from the 'Trainees' table, a subject from the
'Subject' table and a mentor from the 'Mentors' table.

My question is how can i filter the mentors so that my drop-down list only
shows Mentors for the school on the form?

 

[Golfinray]

Allen Browne has tremendous stuff about that on his website,
www.allenbrowne.com.