Value list validation
I have a field titled: Employee, i have another field titled: Assigned_Employee.
Employee = the name of the employee
Assigned_Employee = the name of the employee assigned to the task.
Assigned_Employee has a drop down list of all of the names held within the field: Employee.
How can i write a validation which ensures that the entry into Assigned_Employee is a name that has already been entered into Employee.
I hope this makes sense.
Thanks in advance