Jun 30 2021 05:43 AM
Best,
Is it possible to connect 3 dropdowns with each other. Independence.
Eg.
Field 1 has as dropdown values = Cat1 / Cat2 / Cat3
Field 2 : of which the value depends on what chosen in field 1 (Step1.CAT1 / Step2.CAT1 / Step3/CAT3)
Field 3: the value of this field depends on what is selected in field 1 and field 2
I get this done with dget but disadvantage of this is that I cannot copy it to multiple lines.
Thanks in advance.
Jun 30 2021 05:54 AM
See the attached workbook for a small example
Jun 30 2021 06:10 AM
Jun 30 2021 06:50 AM
Jun 30 2021 07:13 AM
So in fact, you want two drop downs plus one value depending on those.
Here is a modified example.