I have 2 tables - one table has records with a field with a name in it and the 2nd table has records with a field which contains a number of names.
Here's an example:
Table A - Name Field = "Johanson"
Table B - Names Field = "Peterson, Johanson, Smith"
I'm trying to create a relationship that will match any records in Table B which contain "Johanson" in this example, so we can show a portal of possible records to check.
The Names field in Table B is very unstructured but if I switch to Table B and use the PatternCount function that does work, e.g.
PatternCount ( TableB::Names ; "Johanson" )
There will be hundreds of records imported into TableA so we would simply like to import them and see if anything matches. We can't create a simple = relationship predicate, but there's no option to do a "contains" predicate.
Anyone have any ideas how we can get this working?