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?