J
JGM22
I am trying to design an array or something other idea would be welcom
to do the following.
The idea is when the user choose combobox1, they are to choose a pape
size. The paper size has a cost with it which I need to associate wit
but there are two other variables that need to be considered before th
final price is determined. The user would then choose combobox 2 an
choose the weight. The weight difference changes the price as well.
Thirdly, the customer would choose the vendor. Vendor A could have 8.
x 11 @ 20lbs for .01 per page where Vendor B could have 8.5 x 11
20lbs for .075 per page. Lastly, this is all calculated agains
whether the print is color or black and white.
ComboBox1 : this contains ==> 8.5 x 11, 8.5 x 14 and 8.5 x 17
ComboBox2 : this contains ==> 20lb and 28lb
ComboBox3 : this contains ==> Vendor1, Vendor2, Vendor3
1. I am trying to create the comboboxes to feed of of each other. Th
paper size will never change, but I might choose 8.5 x 17 and tha
might only be available in 28lb not 20lb so I want to have only th
28lb be available.
2. The choice of 8.5 x 17 and 28lb would only be available for Vendor
which is whom I am trying to show only.
3. Based on the choices, they answers are then cross referenced an
calulated agains another table to give the total price.
Any ideas where to starts? Array, Lookups? Not really sure myself.
Thank You,
JG
to do the following.
The idea is when the user choose combobox1, they are to choose a pape
size. The paper size has a cost with it which I need to associate wit
but there are two other variables that need to be considered before th
final price is determined. The user would then choose combobox 2 an
choose the weight. The weight difference changes the price as well.
Thirdly, the customer would choose the vendor. Vendor A could have 8.
x 11 @ 20lbs for .01 per page where Vendor B could have 8.5 x 11
20lbs for .075 per page. Lastly, this is all calculated agains
whether the print is color or black and white.
ComboBox1 : this contains ==> 8.5 x 11, 8.5 x 14 and 8.5 x 17
ComboBox2 : this contains ==> 20lb and 28lb
ComboBox3 : this contains ==> Vendor1, Vendor2, Vendor3
1. I am trying to create the comboboxes to feed of of each other. Th
paper size will never change, but I might choose 8.5 x 17 and tha
might only be available in 28lb not 20lb so I want to have only th
28lb be available.
2. The choice of 8.5 x 17 and 28lb would only be available for Vendor
which is whom I am trying to show only.
3. Based on the choices, they answers are then cross referenced an
calulated agains another table to give the total price.
Any ideas where to starts? Array, Lookups? Not really sure myself.
Thank You,
JG