Multi Field Look Up

[bbarrene]

There is a Search form in my database that filters through a query of the mastertable to display the results based on the user's search criteria.

There is one field in the Seacrh form where the user can search for Engineers with a specific degree. I can set the query to look for a degree in one field but what if the engineer has two different degress. How can I make it so the results show an engineer with a specific degree whether it was his or her first or second degree.

Ex: In the "Degree During Recruitment" field, the user wants to search for all engineers who have a "BS Mechanical Engineering" degree. How can I get the results to display Jim Adams, Maty Beth, and Joe Butler, and John Doe as all the engineers who have ME degrees.

I have attached an example database.

Thanks

 

[MStef]

I suggest to use FILTER BY FORM.
(FILTER BY FORM, CLEAR GRID, APPLY FILTER and REMOVE FILTER icons).
Look at attachment (word, zip).