Problem I am having is that I have 2 columns in a database one for item name and one for item description. I used advance search to look up the text and is set on (and) separator what my problem is that when I type text as a whole since it is searching 2 columns it won't exactly find that item. For instance.
when I type Item Name Item Description in the form it automatically searches Item Name Only and not the 2 of them as a whole. Could have been something I did, I am still too new. I would like to know if I can .
Right now its searching one column or another but can they be combined?
What would be the best way to go at this.