AnsweredAssumed Answered

AF Dynamic Table Lookup Fields

Question asked by Stuart_Raynor on Sep 12, 2017
Latest reply on Jun 4, 2018 by sraposo

Hi all!


Can anyone help?

I have a table lookup, and I want to dynamically select the <field> based on the content of an attribute.

I can reference the "Attribute" name in the lookup (e.g. SELECT [%Attribute%] FROM [Table1] WHERE Curve = @Curve1 ) but that means my Attribute needs to be "hard-coded" (fixed text); what I would like to do is replace %Attribute% with something like @CurveName - an attribute that contains the name of the column I want to use.  But when I try to use @CurveName, it just reverts to <Field>, and if I try to use [@CurveName] it claims '@CurveName' does not belong to table Table.


Any ideas what I might be doing wrong, please???