I would like to build out a query that assigns a pre-designated category to a string based on a keyword found in that string.
Attached is an example with two tables. One is a Message table with a string field called TheMessage. The other table is called Category_Fields in which there is one field called "Message_contains" and a field called "Categories".
The Message_contains field has the keyword "chunk" that would correspond to a particular category assigned in the Categories field.
In the end I would like to create a query that included all the fields in the Message table joined with the Categories field in the Category_Fields table that is associated with the keyword found in the message.
If that is less than clear I think the attached database should be self-explanatory.