pruppert

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?

Thanks.

Outcomes