How to update a column in table by matching partial keywords in another table.. for ex :- in "tblkeyword" table we have sleep, run , walk as keywords and in another table "tblData" we have values like abcruntoday, walkman, sleeptiger words .. now how to update a column in table "tblData" .. colname "keyfield" as run for "abcruntoday" and walk for walkman.. need this in ms access i used update query but i am missing on searching keyword and can't ser value..but i have 1000 differnet keywords and 10000 rows in tblData