How do I use custom picker fields for below scenario

Question

I have a code 1110 with value "Farming". When you start typing any of the two values, you get your result. But here I have a list of keywords for "Farming", when I start searching with any of these keyword would it be possible to get the same result i.e., Farming using custom picker field. 
 Ex: I start typing "dairy", would it possible to retrieve selection as Farming?

Mike Schmitt · Accepted Answer

It depends on how your secondary keyword is linked in the database to the primary search result; but in general i think you could probably have the suggest function query search for secondary values.

Jacob Grafenstein · Answer

An easy way to accomplish this would be to have a database field that has a concatenated list of your keywords as the value. For the suggestion function, create a query entity that uses an "includes" operator on the field containing the keywords. This will scan the keyword field to see if any contain the text the user is searching for. For "Selected Labels", use the main keyword field. In this case, it will be the field containing "Farming". Let me know if you have any implementation questions.