I have created a database, which I want to be searchable to my site members.
Currently, I can only find a way to allow for members to search one field of the database.
My question is, is there a code which would allow for multiple field searches to be displayed at once?
As an example - my Database is populated via a form, which contains data such as : First Name, Second Name, Job Title, Location and Salary....
I want my members to be able to carry out a search which would allow them to display people who match a certain variable criteria, such as:
Member searches for : ( Job title) + (Location) + (Salary) = Return of people from the database who match each of the specified fields which have been searched for...
So if a member searched for a user who was a (Lawyer) who lives in the ( United Kingdom) and currently earns a salary of ( £30,000-£40,000) - the database would show a list of people who match all of those certain fields?
Any help would be great! - I hope the above all makes sense!