I have a bit of a problem. I work in a hospital. I have a small database for the physicians confidential quality information on our intranet, and asp page that refers to a view. I have it set up in the query that the Dr’s username has to be equal to the NT_username in the master database. I thought that was pretty clever. Well it turns out that when 2 or more doctors are looking at their quality info at the same time, within about a minute or so, they can see each others info. All of the quality info is in the same table and that is related to the Dr ID table. I dimed a variable uname with the value of the servervariable("auth_user") and wanted to do an AND statement in the where clause that would make username = uname but I can't seem to get a variable from outside my database (uname) to be compared to a field in the database (username)<BR><BR>Thanks for your help in advance.