Hiding Drop Down Values

I would suggest to use WHERE condition in Lookup Wizard setup to display records that belongs to current user only.

I have it set up with a GroupID in my login table and that corresponding GroupID in my Clients table so when the user goes to the Clients page (master page of Reports page) they can only see what is the same as there corresponding GroupID #. The linked dropdowns I mentioned above pull there list from a Criteria table that also has the Client names in it (as field Client) Any suggestions as to how i would set up the WHERE Condition for the lookup wizard, I tried using WHERE "Client = Clients.ClientName" and that pulls the whole list of names again and breaks the dependant drop downs.
Stealth-

I think i might have found a solution, i added a GroupName to the Login table and would like to set that as a session variable at login, then use the WHERE statement with the drop downs to assign the drop down the sesssion variable.
I am having trouble with perhaps the syntax of the WHERE statement, i have:
"Client = ""& Session("GroupName") & "
I also tried adding
Session("GroupName") = rs("GroupName") in the login.asp &
SESSION("GroupName") = dbvalue(rs("GroupName")) in the login.asp (as that is how it looks in my complied login.asp page)
It keeps throwing out a syntax error, if I go into the include/commonfunctions.asp and modify the

strSQL =

statement then it lets me log in but throws out the same error for ClientView_List.asp

( I tried modding the strSQL = in ClientView_List.asp but that is worded very diffrently and beyond me how to change)
I would like to be able to fix all these things in the asprunner program, and i believe with the proper wording for the WHERE statement in the drop down area will fix this.
Any help is much apreciated -
Stealth-

Ok after typing all that i think i have it figured out, normaly i would avoid typing so much here but i hope this all will be helpfull to others if they run into a similar problum.
I fixed the syntax for the WHERE statement it is now " Client = '" & Session("GroupName") & "'"
I also had to add the SESSION("GroupName") = dbvalue(rs("GroupName")) in the login.asp page.
The value if GroupName is being sent to the drop down correctly except now there is a error of

'arr_Group' is undefined

in ClientViewReports_search.asp
That is keeping the dependant drop downs from corectly changing.
Any ideas to a fix?
Stealth-

Without seeing the actual code it's difficult to help.
Publish your application to Demo Account and contact me directly at support@xlinesoft.com.

Without seeing the actual code it's difficult to help.

I published to the Demo account and sent you the email with how to reporduce the problum, thanks again for all your help! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=17301&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Stealth-