Help with calculations?
Ok, I'm 16 days into a 30 day trial, although I have used it only 3 days. It seems once you open the program the clock starts ticking. Anyway I'm new so go easy.
I have two fields, one called "product", that refers to a value list, and one field called "product type".
The "product" value list contains these values
What I would like to do is pick one of these products from a "product drop down list field", and have that action populate the "product type field" with a drop down list of possible choices. The trick is I want the "product type list field" to change according to what's in the product field.
example: If pick windows from the "product drop down list field", I would like to see in "product type list field" different choices of windows, such as
But say I pick Insulation from the same "product drop down list field" I would then want to see the values in that same "product type list field"
Hope this makes sense.