EricWebsite
Member
Hi, I have a Volunteers table, where one can add multiple competences for a given volunteer by using a multiselect dropdown box. So 1=driver, 2=trafic control, 3=guide etc.
Now, in an Events table, I have a Drivers field (database join to Volunteers).
Using another multiselect dropdown, I want to be able to select multiple (drivers only) from Volunteers. How can I do that? A WHERE statement 'WHERE volunteers.competence = 1' leads to an SQL error.
Thanks in advance,
Eric
Now, in an Events table, I have a Drivers field (database join to Volunteers).
Using another multiselect dropdown, I want to be able to select multiple (drivers only) from Volunteers. How can I do that? A WHERE statement 'WHERE volunteers.competence = 1' leads to an SQL error.
Thanks in advance,
Eric