J
JAMIESTEVELEE
I have created a database where I need a set of records from one of
three queries to drop down in a column depending on the value in
another column.
Specifically, my database is for a company that gives guitar lessons,
it has three tables: customers, bookings and teachers and each of the
teachers teach certain guitars (acoustic, electric, bass). I have
created three queries, one for each type of guitar so one has all of
the teachers who can play acoustic, one for electric and one for bass.
In the bookings table, I want the user to pick the type of guitar they
want to learn in one column (type of guitar) and in the next column
(teacher) all of the teachers who can play that type of guitar. So if
the customer picks acoustic in the 'type of guitar' column, only the
teachers who can play that type of guitar appear in the drop down list
in the 'teacher' column.
I hope that made sense.
Many thanks,
JSLee
three queries to drop down in a column depending on the value in
another column.
Specifically, my database is for a company that gives guitar lessons,
it has three tables: customers, bookings and teachers and each of the
teachers teach certain guitars (acoustic, electric, bass). I have
created three queries, one for each type of guitar so one has all of
the teachers who can play acoustic, one for electric and one for bass.
In the bookings table, I want the user to pick the type of guitar they
want to learn in one column (type of guitar) and in the next column
(teacher) all of the teachers who can play that type of guitar. So if
the customer picks acoustic in the 'type of guitar' column, only the
teachers who can play that type of guitar appear in the drop down list
in the 'teacher' column.
I hope that made sense.
Many thanks,
JSLee