Need some help setting up tables in Access

[Vertigo-1]

I'm a bit of an Access noob and I've been given a project involving storing employee info along with their pictures. The tough part is that each employee can have multiple job titles that needs to be simultaneously stored and referenced, and each employee can have more than one office location (3 total) that also needs to be simultaneously stored and referenced. That is, the user needs to be able to see all job titles and all locations the employee has at once if they so wish. Ultimately I need to be able to make a query where the user can search for a job title, and choose a location (or locations), and display all people with that job title on that location. What would be the best way to arrange the tables for this?

Right now I have a seperate table for the job titles, linked back to a main employee table that has a lookup field to drop down a list for the job titles. I have 3 of these lookup fields for the situation of a person having more then one job title...I feel this is somewhat clunky but am not sure how else to do it. For the 3 locations, I have 3 yes/no fields in the employee table, which works great for a basic "view all employees on this location" query, but doesn't work very well later when I need to view employees by job title AND location. I know I need a form that gathers user input, and the query would have to get info from the form...and this is the hard part for me to figure out.

Thanks for any help given!

 

[KLin]

tblEmployee
RecordID,
FirstName,
LastName,
etc

TblEmpLocation
RecordID,
EmpID,
Location,
etc

tblEmpTitle
RecordID,
EmpID,
Title,
etc

You'd probably want 2 more tables setup for titles and location references. That's how I would do it at least. Then have a query setup to see employee info, title(s), location(s), and have the title and/or location searchable.