OK, further to my previous reply, I now have it working for the most part.
What is happening now is if I search for distributors in the United States of America, then I am getting records returned that are also from the United Kingdom… the common word being 'United'… how do I stop this from happening?
And again, if you could clarify what the differences are between an AND search and an OR search, that would be helpful to me to see if I understand them correctly.
Thanks.