I row for a while, and unsuccessfully, to find a solution to the problem below:
Imagine a table with:
* In column 1, list my products
* In column 2, the level of distribution of a product (value = T1, T2, T3, for example)
* In column 3, a number corresponding to the value of column 2 (supplied via a table specifying T1 = 100, T2 =70 and T3 = 30).
Until then, it is very simple.
What I want is in the same table add 2 columns:
* Column 4: equals default in column 2, but this my be modified, by the user either by writing (T2 for example) or drop-down list (display T1, T2 or T3)
* Column 5: depending on the choice made in column 4, I display the corresponding value (eg, if the user selected T2 in column 4, displaying the value 70).
An example in this table:
Product
Distrib actually
Ditrib value actually
Distrib wished
Ditrib value wished
Product 1
T1
100
T2
70
Product 2
T2
70
T1
100
Thank you for your help, that would make me a HUGE Service:-)
