Hi

Wondered if there is a way to display instead of foreign key value some other column value from foreign table with jqGrid MVC .NET.

So lets say I got two tables 1st: Emplyee table 2nd Role table. Employee can be in only one role at a time and is related with Role table by fk as

Employee.RoleID --> Role.ID.

Is there a way to display in the jqGrid Role.Name instead of Role.ID? Note that I am using Entity Framework.

I'd be greateful for any clues

gut

Thats really good and easy solution. Thank u very much noelt.
I done something like:

FROM e in db.Employee
JOIN r in db.Role on e.RoleID equals r.ID
SELECT new { e.ID, e.Name, ... ,r.RoleName };

and then in my grid model i modeled columns accordingly:
"ID", "Name", ... , "RoleName"

All's working fine now. Thanks again! :D