AnsweredAssumed Answered

Help with calculations?

Question asked by deliciousapple on Jan 22, 2009
Latest reply on Oct 16, 2013 by JoRo

Title

Help with calculations?

Post

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

 

Windows

Roofing

Siding

Entry Doors

Gutters

Insulation

 

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

 

6500

B272

P366

 

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"

 

R-19

R-30

R-38

R-49 

 

Hope this makes sense. 

 

Outcomes