You have replies in .excel and .excel.misc

For your help in future posting, it is better not to post the same
question individually to separate groups. Most of the regulars scan all
of the groups and it can waste an awful lot of peoples time answering a
question which has already been answered elsewhere.

--
Regards

Roger Govier


"Abe" wrote in message
news:4Ewvh.821731$1T2.212194@pd7urf2no...
help please....

i am trying to create an order form. normally this would be easy
enough...item price x quanity etc, but there are some other variables.
allow me to explain....

1. let's say we are selling products 1 2 3 etc all the way to 250.

2. let's say that products 1 through 50 only should display options
(styles) of a b c d e f and g, while products 51 -100 should display
options (styles) of h i j k l m etc.

I was hoping the two things above could be in drop down boxes...
so..for example..a customer orders product 22, only the a to g options
or styles are shown.

Now..to complicate things a buit further, each style would have a
different price associated with it.

I was thinking somehow to have the products listed in a drop down
box...and depending on the product selected, would evoke some sort of
condition (If product = 22, display options a-g..where the options or
styles are maybe in an external file?

Does this make sense?

Hope so :)

Any ideas would be greatly appreciated. And please be gentle...I'm a
newbie...but then you probably know that already by the way I asked :)

Thaks in advance,
Abe