| | |
|
|
|
Array, Lookup? |
|---|
| message from JGM22 on 17 May 2004 |
I am trying to design an array or something other idea would be welcome
to do the following.
The idea is when the user choose combobox1, they are to choose a paper
size. The paper size has a cost with it which I need to associate with
but there are two other variables that need to be considered before the
final price is determined. The user would then choose combobox 2 and
choose the weight. The weight difference changes the price as well.
Thirdly, the customer would choose the vendor. Vendor A could have 8.5
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 against
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. The
paper size will never change, but I might choose 8.5 x 17 and that
might only be available in 28lb not 20lb so I want to have only the
28lb be available.
2. The choice of 8.5 x 17 and 28lb would only be available for Vendor B
which is whom I am trying to show only.
3. Based on the choices, they answers are then cross referenced and
calulated agains another table to give the total price.
Any ideas where to starts? Array, Lookups? Not really sure myself.
Thank You,
JGM
|
|
Archived message: Array, Lookup? (MS Access Forms)
