Using selection in one Combo to filter a second Combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having read nearly all of the threads, and advice on this subject I am still
unable to solve this.
I have two tables, tblTrainees & tblEducation.
tblTrainees contains trainee personal details, with primary key ID, &
tblEducation contains details of courses that the trainee is taking. Each
Education record has a primary key,EdcuationID, and also contains TraineeID.
In a subform record I am trying to select, in the first Combo, the name of
the trainee, and storing the trainee ID. in the second Combo I want to limit
the list to the courses the selected trainee is taking, and select the
appropriate course and store the EducationID.
So far all my attempts give me nothing to select in the second Combo.
I would appreciate help with this.
Am using Access 2000
 
Back
Top