I am trying to join two tables in Access that do not have a common field. They both have a "Keywords" field but the text does not exactly match in both tables.

My final goal is to create a query that by entering a keyword from the "Keyword" fields will show the records containing the keyword from both tables.

Any suggestions?
Bronco7