Form conditional combobox

[techsupport1]

Hi all,

First time posting on here but I've been using the website to help develop a database I'm working on. I usually try not to create new threads but have not been able to find anything on my issue so here goes.

The database is for a training course where there are multiple teachers and multiple available courses. Each teacher has different qualifications as to which courses they are able to teach. When a new class is created, first the course is selected, and then I would like only the teachers that are qualified to show up in the teacher combobox.

I believe I have all my relationships set up correctly (can provide screenshot if that helps) and have the proper tables (teacher list, course list, qualification list linking the two in a many to many relationship). I can't figure out how to actively filter based on a selection in the same form

I have a relatively good grasp on what I'm doing, just can't quite figure this one out. Any help would be greatly appreciated

 

[John Big Booty]

Sounds like you are looking for a cascading combo box set.