Search one table using another table as a dropdown
Is it possible to have one table to be used as a look up table to search another table field to see if the exact term selected in select drop down from the (look up) table has the same term in the field of the other table?
I basically want to use a drop down list of different types of expertise to search a practitioner database field to see if that expertise term is present.
Can this be done?
Many thanks