Here is a small script that i have to sumit some data from a field.
What i want. I got in my access databe 2 columns.
One called "Impact". And one called "Reoccurrence".
In the form you can select several data from pull down menu.
Now i want to have a script that does put a VALUE in a other COLUMN called "PRIO". (when the other 2 columns have a specific VALUE)
So when you make the selection HIGH in "Impact". And TOP in "Reoccurrence" then there must be the VALUE HIGH PRIO in column "PRIO"
I was thinking to do this in the HANDLERS.ASP that i did make to submit the data into my access DB.
Here is the script for the handler.