I have two tables, and would like to pull certain results from one table into the column of another. Here’s an example:
Notes & Special Instructions(these would be all
Special Instructionsfrom Order Form that contain any of the words mentioned in in
I can currently do this by adding a desired keyword to look up under
Keywords - but I can only do one word at a time with this code:
[Order Form].Filter([Notes].Lower().Find(thisRow.Keywords.Lower())>0 or [Special Instructions].Lower().Find(thisRow.Keywords.Lower())>0)
So if I put allergy under
Keywords, it’ll pull all text from
[Order Form].[Notes] and
[Order Form].[Special Instructions] that contain allergy. But I want to be able to do multiple words, like allergy, allergies, intolerance in the same row.
Whether I enter them separated by a comma, a list, or whatever, doesn’t matter. Any suggestions?