How do I perform Lookup with calculated Source Field name.

Discussion created by pruppert on Jan 19, 2016
Latest reply on Jan 19, 2016 by pruppert

I want to lookup a value in a related table. However, I'd like the source field to be determined via a calculation field.


For example, I want something like the following:


Lookup ( Table A::theCalculatedColumn  )


where "theCalculatedColumn" is the name of a field that holds the calculated text value of the field to be looked up in Table A.


I can't seem to figure out the syntax for this. Is it possible? How would I do it?