Hey All

I hope a explain the clearly enough.

I have 2 fields from 1 table:
EmployeeID
Employee_Name

I load the ASP page and it fills a Select\DropDown list with the EmployeeName's from the database.

The user selects the name they wish from the list, changes some other details and submits the form.

Now how do i convert the employee name back to the correct Employee_ID??

Especially if their are 2 emplyee's with the same name?

cheers
b