AnsweredAssumed Answered

Delete records from a table based on keywords from another table

Question asked by nickhar on Sep 5, 2018
Latest reply on Sep 10, 2018 by nickhar

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.

Outcomes