Qrew LegendI think it only works in one direction and you want it to work backwards.
One solution would be to parse out the values in that string into separate fields and make multiple report link fields. But that would display pretty ugly on the form and wouldn't scale well if there were more children.
A solution would be to implement the user focus method for which I put an App in the exchange
The workflow would be that the user would push a button on the record. It would then put that record in focus for the user and the string from table A would get looked up down to all records in table B. Then on table B you would have a regular formula which would determine if it was a match and then you would have an embedded report on the table A record, which would only show once the button had been pushed, and that would show the matches.
Feel free to post back with any questions if you're interested in a method which solves the problem by having the user push a formula URL button.
