Greystone Thorngage
12-05-2005, 02:50 PM
Ok, new problem. The "helps" i have found on the net only confuse me or offer no help.
I want a drop down box. List A-Z. Upon selecting (example) A, i want it to query a table and list the responses in another drop down box. Cascade like that multiple times. After that is complete i need it to do a calculation.
So.
1. select Model -> A
2. use that selection to query a room list
3. select Room -> Master Bath (which is one of the rooms that a model A has)
4. select Flooring -> Carpet (there is three options contained in a table this one is easy)
5. select Style -> Cheyanne Berber (also easy, simple table query, i can do this too)
6. Now the hard part. There is a table that says a Master Bath of Model A is 94 sqft of carpet. It then needs to take that number and multiple it by the cost of a sqft of cheyanne Berber (which is located on another table) and then output the result. so 94 x $1.30= $122.20. <~~~need it to show that.
I assume there is some VB programming in volved which i am slightly versed in. I just need to know how to calculate based on variables selected in a drop down list.
I want a drop down box. List A-Z. Upon selecting (example) A, i want it to query a table and list the responses in another drop down box. Cascade like that multiple times. After that is complete i need it to do a calculation.
So.
1. select Model -> A
2. use that selection to query a room list
3. select Room -> Master Bath (which is one of the rooms that a model A has)
4. select Flooring -> Carpet (there is three options contained in a table this one is easy)
5. select Style -> Cheyanne Berber (also easy, simple table query, i can do this too)
6. Now the hard part. There is a table that says a Master Bath of Model A is 94 sqft of carpet. It then needs to take that number and multiple it by the cost of a sqft of cheyanne Berber (which is located on another table) and then output the result. so 94 x $1.30= $122.20. <~~~need it to show that.
I assume there is some VB programming in volved which i am slightly versed in. I just need to know how to calculate based on variables selected in a drop down list.