This is annoying - I know this, having done it many times before.
However, I can't remember what to put in my key value so that the key is searched for across the first two columns:
I have a View whose first column contains LookupType & is categorised, the second column contains LookupCode & the third column contains LookupValue.
I am trying to return the value from the third column, based on the value of the first two:
@DbLookup(""; ""; "Lookups"; "LookupType\\" + FieldContainingLookupCode; 3)
I thought I needed to concatenate the two values in the Key string using a backslash, hence I have placed a double backslash (as the first one makes the next character literal, so \\ becomes \ ).
But this doesn't work. Can anyone tell me where I am going wrong?