Has anybody done or can help with multiple fields on one line. We are looking for something similar to using the three search lines with and AND,but for speed of use just want to type it all on the first line.
So in the demo for example going to inventory search, and putting "red shirt" in the description will give you all the red shirts. The same as putting red on the first line, and then shirt on the second line.
The Like statement allows us to do red%shirt but this would only work if the first word came first.
Apparently the old Clear system did this nicely, so we would like to match it.
Cheers,