Hi <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
I have a form which has a list menu of several items. What i need to do is have the item name sent to an SQL table, and for the value to be sent to a hidden field which resides on my form.

Example, If a User chooses the first item on the list menu, which is 'BOARD'- then when the form is submitted, i want BOARD to be sent to a field in the SQL table, but the value 102 to be automatically sent to a hidden field on the form.
Similarly if the second item, 'NMPCT' is selected instead, then i need NMPCT to go in the SQL field, and the value 103 to be sent to the hidden field on the form.

The values captured in the hidden field are to be used to help prevent duplication of entries made on the form.

ive have been told to use an array solve this problem but ive never used one before.

any help would be much appreciated