
I have 2 fields, LOB(User) and New LOB.
How do I do it, when I select the value "Wholesale Banking" or "Wholesale Funding" from the LOB(User) field, the value of the New LOB field will automatically change to "LOB Wholesale Banking Group"
if LOB User = Commersial Banking Supply Chain, set New LOB = LOB Wholesale Banking Group
can anyone provide an example query?