I'm coming with a quite simple question - I guess - but I somehow can't find the best/easiest way to achieve that.
I have a form with a dropdown column 'column1' which has a few choices. In my case it's about the amount of memory (8GB, 12GB, 24GB, .... 128GB). Now I have another column 'column2' where I want to set a value, already in the new form, depending on the choice of column1. E.g. if column1 equals 8GB or 12GB than set column2 to value 'AAA'. If column2 equals 24GB or 36GB than set value column2 to 'BBB' and so on.
I tried to do it with an additional list and lookup fields and with calculated fields without success. I guess there must be a quite simple solution vor that, but i can't see it
Thanks in advance for any help.