Identifying values...(CF newbie post)

[Adrienne H. Cregar]

Hello all... Hope you can help. I'm new to CF and can't seem to figure
this out - should be obvious but it's not. I have 4 tables within a
database, each of which have an id#, product name and cost (like this):

Table A fields: IDA, ProductA, CostA
Table B fields: IDB, ProductB, CostB
Table C fields: IDC, ProductC, CostC
Table D fields: IDD, ProductD, CostD

I have a form where there are 4 select fields populated by the product
names within each table. What I want to do is to identify the cost (the
value for the cost field in that record) for that product based on the
product selected, so that I can perform some calculations based on it.
In other words, if Product A is selected from the form, I want to get
Product A's price and pass it to the results page, where I will then
perform calculations based on that cost. How do I identify the cost
value based on the product name selected? How do I pass that along? I
tried using a hidden field to pass the value, but it listed the costs
for each record - not the one selected. Right now, my results page just
posts the choices that the user selects... that is working fine. Can't
figure out how to get the cost identified and moved over there... Any
help you can offer would be greatly appreciated.
Thank you in advance!

A.Cregar
[EMAIL PROTECTED]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists