You display an "Employee ID" column with a numeric editor.
Let's assume this a foreign key value to an employee table.
The numeric editor is insufficient because a value can be selected that does not exist in the employee table.
What is the best way to represent a foreign key in the grid [display and editing]?
I have seen the drop down data source, which works for editing, but fails for displaying because the Id is still shown in the grid, rather than the display text [in this case, it could be the employee's name].