Here is my problem:
I have 2 tables unrelated. The 1st one called Products has 10 fields. I have a calculation field that combines the contents of the fields I want to search in. The 2nd one is called Keywords and has only one field with keywords, one or many words each.
I want to able to find and export all the products that contain any of the keywords.
Any ideas how to proceed?
Products table has usually more than 90,000 records and Keywords always more than 450,000 records
Every idea is welcome.