what you want can not be done by a relation.
relations are always exactly equal, non-equal, lower, bigger, crossjoin. but not partly equal.
you must make a script that takes the search criteria from table 1, and searches in table 2 for "*" & criteria & "*"
greetings from germany
"*" & criteria & "*"
...does not work.
Is that typed correctly?Can that be used in a script?
Maybe I'm using this for the wrong purpose.
I need a script to basically say:
If "field" contains "anyOFthisText"...then...