Search a field for any match
I have a field set as a dropdown list Displaying the values from another table and Auto-complete using value list is selected.
This is great because i can start typing and it instantly offers a variety of options to choose from, however the options listed are only those which match the first word.
e.g. When I type (ob) options are: observer variation, obesity, obstruction, etc.
but i will not get options for: male organs, migraine ocular, migraine ophthalmic, etc. where there is a preceding word.
My question here is if there is a way to create a field to search from a list of values in this manner, and if so how might one create this.