I want to thank you first for giving me information I needed to change my 

OLEDB path. Now I run into another problem and hope everybody can give a 

hand.



Senario: a user enters his account number to retrieve account info. This 

user has a manager above hime-upper hand and somebody below him-down hand. 

So his account number could appear in any of the 4 separate dealers' 

columns. How can I use .asp to check his account number against the 4 

columns and list all information related to him.  Further, how can I also 

retrieve his down hand info. at the same time?  I feel that I need to use 

if and select case syntax, but I'm new to ASP and don't know how to start. 

Any suggestion would be helpful. Thanks in advance.