Hi,
Does anyone know how to perform lookups to display the description of a field rather than its key value in a radgrid using the built in features of the grid - I've tried including the foreign tables/fields in the SELECT statement but then the update/append/delete features don't work properly.
For example instead of displaying EmpID I want the grid to display the employee name, but the employee name is stored in a different table.
I've got this to work in a new template column using a combobox but this is only visible whilst editing! :o( I need the value to be displayed in the grid proper.
Any help would be appreciated! :o)
C.
Does anyone know how to perform lookups to display the description of a field rather than its key value in a radgrid using the built in features of the grid - I've tried including the foreign tables/fields in the SELECT statement but then the update/append/delete features don't work properly.
For example instead of displaying EmpID I want the grid to display the employee name, but the employee name is stored in a different table.
I've got this to work in a new template column using a combobox but this is only visible whilst editing! :o( I need the value to be displayed in the grid proper.
Any help would be appreciated! :o)
C.