I am having a problem with an SQL statement and I wondered if someone may have a suggestion.
I have a drop-down list on "pageA.asp" with the action set to pageB.asp" that displays all the departments in my county,
and on pageB.asp I have my sql that displays the addresses of the departments.
Now in each record that displays, there is a link that takes you to "pageC.asp".
On pageC I need to list all the employeesk at each address (from pageB records).
In the sql on my pageC.asp is there a way that I can use a WHERE clause that will grab the employees that are at each address AND from each department?
Example: I have this WHERE clause on pageB to grab the records from the drop-down on pageA where it displays the departments and the addresses of each.
WHERE DepartmentID.DeptName LIKE '" & Request.Form("departments")
Now on pageC is there anyway to use a WHERE clause to grab the records from pageA, since the action on pageA is set to go to pageB??
What I need to do is to be able to list records on pageC that are employees of each department from each address.
Hope this isn't confusing.
If anyone can help, I would appreciate it.