Hi,
I have a form where we have a list lookup and the value of the selected item is used in the formula of a calculated field to retrieve a value from another list.
I want to use the result of the calculated list in the filter of a second lookup list.
The calculated field uses this as its formula this works OK
|
lookup("/sites/payment|Companies","Entity",""+parseLookup(CompanyName)+"","Easy Code") |
The filter for the second lookup is in the attached file. EasyCode is the name of the calculated field control.
Any help would be appreciative