Report link - target field value is contained in
I have Table A and Table B. I would like to create a Report Link in Table A, which returns multiple records from Table B.
In Table A, I have a text field called AllDataPoints with value:
189-261 ; 189-21 ; 189-101
(It was originally a summary field of combined text, i.e., multi-select text, so I can play around with the delimiters and such.)
Table B has a field called MatchID (text). I want the Report Link to return 3 records from Table B -- the record with MatchID equal to 189-261, the record with MatchID equal to 189-21, and the record with MatchID equal to 189-101. In other words, I want records where MatchID is contained within AllDataPoints.
I tried changing Value Matching to contains and wildcard. My guess is that it would work if values in A were substrings of values in B, but I want it the other way around -- return records where B is a substring of A.
Any ideas? Thanks.