Redirect url based on database value

Hi all
I want to be able to re-direct clients who click on a URL link to a certain category.
The link would be http://www.mydomain.com/category.asp?cat_id=2

The category has a terms required select box yes/no
On clicking the URL I need to check if the terms value is yes or no, if it is yes I need
to re-direct the client to a terms page and then onto the category selected, if its no
then staight onto the category page.

On the terms page I need a way to get the original requested URL ?cat_id=2

I have read about session variables and stored URL's but can't seem to figure out
where to start.

Grateful for any help from you out there
ck

Instead of a URL link why not use a form button since you also have a Select Yes/no form field. This way when you go to the action file you will have the category Id and Select values readily available in:

Request.Form("id") and Request.Form("Term")