I have a table with two fields. EN | SP Hello | Hola I | Yo Both the fields A and B represent the same vale in two languages. I want in a drop-down field , the Spanish value automatically selected, when english value is set to a specific word. It should also work , if I set the spanish word.
Thankful for any ideas!