Drop Down Menu

[ptuck]

I have a little problem. I created a web form to use to evaluate people. I have a drop down box that is populated from a database table with names. What I want to do is have the name eliminated from the list as it is evaluated. The catch is that multiple people will be evaluating the same names. Meaning I can't remove the name from the list permantly just for this one particular user. Any ideas on how I can flag this and remove it from the list?

 

[mattygriff]

Please provide details of your database tables. You will need some way of cross checking your reviewers and reviewees.

 

[foxbox]

Do i understand it correctly that person A can be evaluated by more than 1 person? So if i use your page the drop down box should show only names that are not evaluated at the moment by me[/]?
I suppose (and hope) you have a table that stores who is evaluating who. Then you can do something like this:

SELECT p.personid, p.name FROM PEOPLE p
WHERE p.personid NOT IN (
   SELECT personid FROM EVALUATION
   WHERE reviewer = 'FOXBOX')