Enable "and/or" on custom search form

[June7]

Applying multiple parameters with AND operator to the same field is another issue.

Cannot do: ([LI_ProdFea][kf_Feature]=[searchtext1] and [LI_ProdFea][kf_Feature]=[searchtext2] and [LI_ProdFea][kf_Feature]=[searchtext3] )



No single record can meet that criteria.

Another reference to Allen Browne: http://allenbrowne.com/ser-50.html

[DB88]

I know I cannot do that equation, hence my note "{Note: this is a simplistic view of the "and" problem, I'm probably going to do some looping or concatetation to solve it. I used this just for explanation}"

Thanks for the reference, I also am finding this link helpful http://allenbrowne.com/ser-28.html

[June7]

Allen Browne to the rescue again! Sounds like you have a good handle on where you need to go from here. Good Luck!

[rpeare]

Here's an example for your AND search
DB88.zip