I have a database where employees have four specialties. I have one table with employee info containing four ID fields for each specialty. The specialties (name and ID numbers) are in another four tables (Specialties 1-4). I then have a query to link the employees and specialties from the two tables using the specialties ID number. I could only make it work using the four tables. Is this the best way to go?
B/c now I need to create a search form where I can let users search the four specialty fields to find staff they can work with. For example, if someone was looking for a facilitation expert they could pull "Facilitation" from a drop down list and then see those staff that are "facilitation experts". Thanks in advance.
I kind of see where you're going with this but I'm having trouble trying to visualize how to physically make the joins in the query (if I even have to) based on the new empl_specialty_id and the four specialty IDs that exist for each staff member. Attached is what I currently have if that helps. Thanks in advance.