Hi I apologise if this question has been asked before, I have looked through the forum but have found it hard to find an answer that fits my exact issue.

I am trying to set up a quick search facility on the database. I have created a few fields that are only to enter search criteria and on starting the search are stored as variables and the "search" fields themselves are wiped. The first field is free text that searches all fields and the other fields are specific to certain fields eg name. At the moment the search brings up records that match any of these fields, but I would like it so it only brings up records that match all of the fields eg if the free text says benidorm and the name says Fred in the search criteria it only brings up records that have Benidorm in any field and Fred in the name field.

Regards

John

Perhaps, this might be of interest: SeedCode's Search