The purpose is to construct a where clause to limit records returned by a query.
Here's what I'm thinking.
A memo field to hold the keywords.
A (lookup) table of keywords.
To maintain control/ quality of entry the user picks keywords from the list (can be multi-select)
The user can add to the list.
Not sure how a search would work
Free typing? sounds nasty
Pick from a list
How would the sql statement be constructed? - I assume I'd need wildcards
Will this work on the memo field?