Hi,
There's no great way to handle with this with a regular ValueList. But you can do it with an UltraDropDown control as your ValueList. In fact, I did this myself for an application I wrote years ago.
What you do is replace your ValueList with an UltraDropDown control. Set the ValueMember and DisplayMember to the EmployeeId and Name fields respectively. The UltraDropDown can display multiple columns. In this case, you really only want to display one, so you would hide all but the Name column, but the presence of multple column is significant because it allows you to have an additional field on the list like "Active". Then what you do is handle the InitializeRow event of the UltraDropDown and examine the cell value of the "Active" field and if the person is no longer active, set the Hidden property on the row. This hides the rows from the user, but the editor can still use it to translate the ID to the Name.
Thanks, this worked for us too.
Using v9.1
But just wanted to know if Infragistics has already worked on any new way to handle this.