Keyword Search

I've created a keywords search field and was hoping to allow people to enter keywords which currently does work, however, if I enter two words that are not together in the search box (i.e. the dead instead of the grateful dead) it will return zero results. If the keyword is in the keyword field, regardless
of it the two words are actually next to each other, I want the results return.

You can set the "implied OR" in the server behavior to use space and then it would search for "Greatful" OR "Dead"... or the implied AND.

Not sure what you mean by "implied or" but using and OR statement would return any record that has Grateful or Dead, but not what I'm looking for. I want it to return only those records that have those words even if a word is in between them. So again in the keywords "The Grateful Dead" are in there and I want to return those records even if a person types in "The Dead" (without quotes of course) I still want it to return those records. So it's really an AND statement no?

The "Keyword AND" option will be available when you use type "Keyword" for your search. Set it to space and set the OR to comma-space (opposite of the default).Capture.PNG

If I do that I get the following message

You must not have a column selected in the select list.

The column I want "keyword" to use is not listed...

Choose a different column and then update it in the code after application if necessary.

I set it as indicated in the attachment and now returns all records

Are you doing a post with a form element named "keywords"? I'd need FTP access and a URL to reproduce to debug.