quinn222

Can anyone on my flist assist with this question?

If I have four products:

a = $10
b = $20
c = $30
d = $40

I want to create two fields on the form, one a drop down box where the user enters the choice of a, b, c or d. I then want the corresponding field to automatically fill in the price. On the form and on the table of customers.

As far as I have been able to figure out I need my table of customers and then I need my table of products. I can make the drop down box where they choose the product but not make the price appear in the price box.

Help. Please.

I had an annoying customer service experience this morning. I wanted to buy something for my camera. They have it on Amazon but we have a local camera store so I figured I'd go there and give them my business.
I was the only customer in the store. I told the guy what I wanted and he was so rude and condescending to me. He didn't even let me finish saying what I had to say before he cut me off. He was telling me I shouldn't buy the thing I went there for and was all set to steer me to something ten times the price that I didn't want. He was all, you shouldn't buy that, that's only for shooting manual.", looking down his nose at me as though there was not a chance I'd be shooting manual. Not to mention even if I didn't shoot manual (which I often do) I'm in there to buy something in his store. DO NOT CONDESCEND TO ME. Even if I went in there to buy batteries for $50 point and shoot (rather than an accessory for a high end digital SLR) he should be gracious. I also wanted two other things. I walked out. I'll buy the things I want at B&H or Amazon. I'm never going there again.

Is the economy so good you can afford to have customers walk out vowing never to darken your door again? And all I did was say "I'm looking to purchase one of these, do you have one?" Though I never got to the second part of the sentence before he cut me off to tell me what a moron I am (pretty much.)

Oh, and one more thing (yes, I am ranting), the thing I was looking for? That is useless and I am stupid for wanting? I was looking for it because it was recommended by Scott Kelby. Yes, this Scott Kelby:

Scott Kelby is the editor and publisher of Photoshop User Magazine, Layers magazine (the how-to magazine for everything Adobe®) and President of the National Association of Photoshop Professionals (NAPP).