Drill Down Application

[greybeard]

Using DW 8/ASP VBscript. Am a Newbie. I am wanting to create a page that will list manager's names created from an SQL query. I have done that. I want to be able to click on the manager's name and link to another page using the selected manager's name in another SQL query to produce employee information that reports to that manager.

Really need help with this. Thanks in advance for your assistance.

[Newsgroup_User]

You have a page that lists manager's names.

In their names, put the following link:

<a href="EMPLOYEEINFO.asp?cid=<% RECORDSET INFO FOR PRIMARY KEY%>">Manager's
Name</a>

Simply drag the primary key's value to your link and put the code in behind
an assigned value, which in this case I designated as cid. So, at the end
of your url, tell the browser there's a variable (?), define it's name (cid)
and show what it's value is (=<% RecordsetInfo %>.

Then, in your next page setup your Employee Info recordset to catch the url
variable with the name CID and sort records according to it.

Coincidentally, you can combine these into the same page, using a drop down
list for the names and a show/hide to show the drop down if no employee is
selected (ie, recordset with url variable is empty) or employee info if
recordset is full (ie, employee has been chosen).

HTH,

Jon
"greybeard" <webforumsuser@macromedia.com> wrote in message
news:e4crmu$j3$1@forums.macromedia.com...
> Using DW 8/ASP VBscript. Am a Newbie. I am wanting to create a page that
> will
> list manager's names created from an SQL query. I have done that. I want
> to be
> able to click on the manager's name and link to another page using the
> selected
> manager's name in another SQL query to produce employee information that
> reports to that manager.
>
> Really need help with this. Thanks in advance for your
> assistance.
>