I have the following challenge. I have list from which the user selects a value from column A, based on that value I need to populate two other fields on the form with values from column B and C based on the selection made from column A.
I have tried using three look controls,
lkColA: does a souce list lookup and presents the required choices, I then use a calculated field strColA to parse the lookup value to have choice as str.
lkColB: does the same source list lookup and attempts to filter on the value in the in strColA and return a single filtered value from the item selected
lkColC: does the same source list lookup and attempts to filter on the value in the in strColA and return a single filtered value from the item selected
lkColA and strColA work fine, but the other two lookups do not filter on strColA.
The only way it works is if I hard code the choices for lkColA then filter lkColB and lkColC on the value selected on lkColA.
This is not a real solution as the choices in lkColA will change and i would have to keep updating the choices manually.
Clearly I am missing something