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???