mccartc1
Novice

List lookup filtered on the value of a calculated field

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 

 

0 Kudos
Reply