Hi - I am looking to do the following :
(I posted this question before but cannot seem to locate it!)
I would like to assign a category to the master table (Master Table) based upon search criteria in another table (Table 1)
Example
Master Table (input)
ID | Text | Category |
1 | I like ice cream | |
2 | Apple trees are growing in the yard | |
3 | Here is a bowl of nuts | |
4 | I ate some ice cream on Sunday |
Table 1
Search Text | Category |
Ice Cream | Dessert |
Cake | Dessert |
Banana | Fruit |
Apple | Fruit |
Petzels | Snack |
Nuts | Snack |
Final - Master Table (output) - search Text field so to speak and determine the category
ID | Text | Category |
1 | I like ice cream | Dessert |
2 | Apple trees are growing in the yard | Fruit |
3 | Here is a bowl of nuts | Snack |
4 | I ate some ice cream on Sunday | Dessert |
Any help would be appreciated - Jerry