AnsweredAssumed Answered

Relationship between field with 1 value to a field with a list of values

Question asked by ChrisWondra on Feb 27, 2012
Latest reply on Feb 27, 2012 by philmodjunk

Title

Relationship between field with 1 value to a field with a list of values

Post

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.

Thoughts?

Outcomes