Hi I was thinking of a keyword search feature in one of my projects. I have Essential Oils that I want to keyword in a "Keyword Text Field" for example.

Wood, Sweet, Fruit, Strong Aroma.....

What would be the best search function for a feature like this? Would it be Possible to enter multiple features in one search field and it lists all compatible Essential Oils. How could that be done?

Thanks, as always!

I believe what you are describing is similar to a check box value list scenario.

Values must be stored in a return delimited format in a field in order for searches to work as expected.

So for example you would input:

Red

Blue

Green

into a single field.

Then on the search screen you could use a checkbox value list to select one or more values to search for in a single field.

Make sense?