guru minds needed

<select name='work_experience_factor' size='1'>
<option>SELECT</option>
<option value="2">Accountants:Experience - year 1</option>

This displays the value that gets passed to my processing page when someone chooses an option, in this case 2.
The part that is between each set of option tags is just what the user sees when they're selecting...it doesn't go any further along.
This is what i'm using to pass the values thru the .asp(s)
and into the db:
<%
For Each thing In Request.Form
Response.Write "<input type=""hidden"" name=""" & thing & """ value=""" & Request.Form(thing) & """>" & vbCrLf
Next
%>

There must be a way to pass the part the user sees as well so i can do:
If work_experience_factor = "Accountants:Experience - year 4+" Then
do something...
End If
So i put into calculations the same option twice.

Does anyone know, may the language to do it, the script to do it? even links to info about it?
Keep in mind i'm using fp>asp>access dnsless, yes i know i'm limiting myself. I know it can be done if i restructure, but to me forward is the way to go!

I think I understand the jist of it. The user sees a value(s) and you need a different value(s).

These values should be in a table. This table has your value, the users value and a unique key value. The hidden field should contain the key value. In your vb script, you relate the key to your value to indicate the task to perform and it will also point to the value to display to the user.

Example:

Customer:.....Discount:....Key:
Member........5%...........100
Senior........10%..........101
Special.......25%..........102
Employee......15%..........103


Your Option box shows the Customer column. The hidden field shows the Key. The vb script looks up the discount based on the key.

Hope this helps (or points you in the right direction).


TB_Guy_2000

thanks that open a few doors for me. also i'm doing this post to db, i've never done one before, usually only get info from db. I'm having problems showing my last part of the form, it seems to jump to a conclusion that is only available in the last part, i must be directing it poorly, its driving me bonkers. could you have a look at it, i posted it on brinkster.com you can e-mail me at [email protected] for user names and psswerd, it would be much appreciated, Thanks..