I would like to display in a dropdown the list (in workflow 6.0) of all active users in the altiris contact table (this part I have done). I also want the list to default to the name of the person who is currently connected to the webfrom. I have the information of the NT_ID from the get current user component but i'm not sure how to use this information to have the dropdown default to that person name. Any ideas? Does my SQL need more info in then just
Select name, NT_ID, EMail
from Contacts
were status = 'a'
order by name