Hi,
I am trying to make a database for my banking data. I would like to search the description of the transaction and assign it to a category. For Example
Description: "Withdrawal Bobs Electric Company 10102010 "
The description always has some date code that screws things up so I would like to just search the string for keywords "Bobs Electric" and assign a category like "electric bill" for this.
I was imagining some type of 'relationship' based on keywords. Maybe a table that looks like:
KEYPHRASE, CATEGORY
Bobs Electric, Electric Bill
Bills Electric, Electric Bill
Beans and Gas, Natural Gas Bill
The Gas we Pass, Natural Gas Bill
Progressive, Insurance Bill
Molasses Internet, Internet Bill
Wall mart, Wall mart
The query would read the description of a transaction, and if it said Beans and Gas, the Category column would return "Natural Gas Bill"
So I am wondering if this is possible and how I should go about it. From what I know about relationships this will not work, but perhaps some complex query... Any suggestions?