Good morning, everyone,
I need your help. I am creating a form to book courses according to the courses offered by the teachers.
Let me explain, the client selects in the form the name of the teacher with whom he wishes to work.
And in a second field, I would like only the courses offered by the chosen teacher to be displayed.
I created a database per teacher.
I have 3 professors: Professor A, Professor B, Professor C
And each teacher gives 3 classes.
Professor A gives the courses: math, French and geography
Professor B gives the courses: history, English and physics
Professor C gives the courses: Biology, chemistry and sport.
Here’s what I’d like to see in the form:
Question: Select your teacher?
Answer: Professor B
Question: Select your course?
=> only the courses offered by Professor B would be displayed.
Is this possible and how?
Thank you in advance,