Sorry if this sounds like a "you should know that question", but I have a form with 2 combo boxes. I would like to limit the 2nd combo box depending on what I selected in the 1st.
For example, I have 3 tables. One is teacher, one is subject, and the last one is subject_taught. I now have a form to update a 'class' table. By picking the subject, I limit the teachers that can take that class (I can get the combo box to show all subjects). I know I have to create a query to query the subject_taught table, but I have completely forgotten how to do acheive the whole process.
Thanks.
For example, I have 3 tables. One is teacher, one is subject, and the last one is subject_taught. I now have a form to update a 'class' table. By picking the subject, I limit the teachers that can take that class (I can get the combo box to show all subjects). I know I have to create a query to query the subject_taught table, but I have completely forgotten how to do acheive the whole process.
Thanks.