Relationship between field with 1 value to a field with a list of values
Is there a way to have a relationship between a single value and a list of values. Example: Table A has a field called IDNumber, Table B has a field called IDNumberList, I need a relationship that would see that IDNumberList "Contains" IDNumber.
I'v tried filtering, FindValue functions, PatternCount functions, Global Variable tricks, etc. to no avail.
I can get it to work with scripting, but that will not be a good idea as there will be several hundred thousands records.