I'm trying to come up with the correct scenerio to search and find products and like products from a master file.
I have 3 tables
Table #1 is the Master file
It has two fileds that I care about
It has 2 fields similar to table #1 but the Extended has had the - stripped from the vale
The 3 table has the value to search for
In this case I want to search table # 2 and return any Extended values that are like '%123%'
Return from table 2 ID's Item123 and 123Item.
Hope this makes sense