Hi John,
Thank you for your post. I've just re-read my post and realised how badly
it was written! Each table has a numeric primary key related to it's title
(eg for Trainees it's 'TID'). The Subject table contains only info relating
to the subject. The Schools Table contains info relating only to the school.
The trainees table has info relating to the Trainees and Subject ( 1 trainee,
1 subject). The Mentors Table has info relating to the mentors, their
subject and their school (1 mentor, 1 subject, 1 school). The placements
table ties all these together as each Trainee has three placements at
different schools with different mentors.
I have forms set up for Subject, Trainees, Schools and Mentors.
Placements are entered via a subform on the Schools form or the Trainees
form. The fields in this table are Trainees (TID), Subject (SUBID), School,
(SCHID), Mentor (MID) and Term.
What I would like to do is filter the list of the Mentors' names on this
form to only show the mentors for the particular school placement.
I hope you can help me.
Thank you
John W. Vinson said:
I have a dbase with 5 tables [Trainees] [Schools] [Mentors] [Subject] and
[Placement].
I have [Placement] set up to accept input from [Trainees], [Schools] and
[Subject].
[Mentors] has relationships with [Schools] and [Subjects]. (Each School can
have several Mentors and each Mentor specialises in a Subject.)
How can I set up [Placements] to input from [Mentors] filtered by [Schools]
and/or [Subjects]
Any help gratefully received.
I'm not clear what you mean by "accept input from". What is the Primary Key of
each table? What relationships do you have established (by fieldname)? What do
you mean by "set up [Placements]"?
One other question: each School can have several Mentors, and each Subject can
have several Mentors. But can one mentor serve more than one school, or
support more than one subject?
