Drop down list
My question arises because it would be useful that, once a row is selected in a drop down list (combo box), the value contained on a different column could be fetched and saved to a text box. That is, for instance, if I select Product-type it would be nice to get its unit-price and put it in a cell.
Then, how can I fetch a value in a different column of a selected row and save it to a text box?
I tried with Actions & Validations, but it doesn't seem to work.