I was trying to do a 2 level dependent drop down list, but could not get it working.
I have list of Bank Name Drop down then then list of Account No and Then list of FX.
In first list to choose, I place in Bank Name Column this validif = Bank[Bank Name]
Then in Account No Column validif = Bank[Account No]
and now from these account no, I need to choose drop down list of all the currencies
so on Currencies Column I place validif = Bank[FX].
I manage to get the dependent drop down to Account No, but not to the Currency.
I am not sure where I make the mistake is.