Help Please!<BR><BR>I am performing a lookup function that pulls a salesperson from the database based on security levels. I can get it to pull only the user that is logged in, but I am wanting administration level people to be able to see ALL sales people. <BR><BR>I am using "rep" as salespeople and "adm" as administration. <BR><BR>I only want salespeople to see only their name in the dropdown box. <BR><BR>I have declared a session variable on the login page, but I am not sure how to reference it in this case.<BR><BR>Hope this makes sense. I know it is confusing.<BR><BR>Here is my code:<BR><BR>Set RS2 = Server.CreateObject("ADODB.Recordset")<BR>SQL = "SELECT DISTINCT ac.hMy, ac.sAssoc, ac.sSecurity FROM assoc ac, district ds" _<BR> & clsWhere & " and ac.cInactive = &#039;n&#039; and ac.sAssoc &#060;&#062; &#039; &#039; " _<BR> & " and ac.sSecurity = &#039;adm&#039; or ac.sSecurity= &#039;rep&#039; "_<BR> & "ORDER by ac.sAssoc"<BR>Set RS2 = Conn.Execute(SQL)<BR>&#039;If there is no record then exit the sub routine<BR>If RS2.RecordCount = 0 then exit Sub<BR>While NOT RS2.EOF<BR> hID = RS2("hMy")<BR> If Session("User") = RS2("hMy") then<BR> sAssoc = RS2("sAssoc")<BR> If cint(hID) = cint(Assoc) then<BR> Response.Write "&#060;OPTION VALUE = " & hID & " SELECTED&#062;" & sAssoc & "&#060;/option&#062;"<BR> else<BR> Response.Write "&#060;OPTION VALUE = " & hID & "&#062;" & sAssoc & "&#060;/option&#062;"<BR> End If<BR> End If