Hello. I'm getting in a state trying to keep certain records from being shown through web-companion...

I have a field called "searchable", which defaults to 0 and can be changed to 1, only by the administrator. When people search the database on the web I would like only records with this field value set to "1" to be displayed.

Sounds simple enough, but when the search form is sent, the search criteria always seems to be OR.

Ie, I am trying to get the query to be in the form of:

Show all records that field Searchable = "1" AND (field Name = "john" OR field Age = "25" OR......) etc.

Really grateful for any help!

You can get the searchable filter to work using "-lop=and" but you can't have it work in conjunction with an "OR" search. You can search for "john" in the searchable records and then do another search for age of 25.

you could also filter them out on the results page by putting

[fmp-if: searchable.eq.1][fmp-record] record details[/fmp-record][fmp-else][/fmp-if]

Simon