OK-

Before I spend hours and hours doing this, could someone point me in the right direction?

This would be SO easy to do with straight asp.net, and I probably out to think about creating my own module.  But.

What I need is this:

1) A member of the website will log on and create a location record.  They will enter their address, city, state, etc.

2) I will use a UDT with a DISTINCT SQL clause to group each of those location records by state. 

3) An incoming visitor should be able to click that link and go to????? another page with a UDT that has all the entries for that state?

So basically, I want to create a one to many relationship.  I'm not sure if I pass a session variable or a querystring parameter, or if there is some other way.

Any suggestions?

Many thanks,

Sam