I'm trying to search for records that contain two or more words.  I don't want to search them just as a string. (i.e. searching for the two terms "firecracker" and "green"  would find a record with "we sold a green flask described as a firecracker" and "we sold a green firecracker flask").  I built a custom search form, but that returned any record with either term.

FF tech support just told me a custom search form couldn't do this, and that I would have to use the search bar's "Search All Fields" to do it.  I tried that and got the same results - it's returning any record with either term.

Thanks

Doug