Let me describe the example i am looking for. Lets say we have following tables.
EMPLOYEE ( EmpNo, Name, FK_DepartmentNo, FK_RoleID) -- FK stands for foreign key.
DEPARTMENT (DeptNo, DepartmentName)
ROLE ( RoleID, RoleName)
VIEW_EMPLOYEE( EmpNo, Name, DepartmentName, RoleName)
Now I want to use CRUD operation on EMPLOYEE table using Grid. While listing data in grid, I will list data from View_Employee, but while editing grid I want Insert/Update/Delete to act on EMPLOYEE table. I want to use Form Template during Edit, so that i can bring appropriate list to fill into Department and Role Dropdown controls respectively.
Can anyone point me to such a real life example to understand how it can be done with telerik grid.
The Telerik samples of grid shows examples where data comes from single table like Contacts Table or Products Table with simple text columns and that does not simulate real world scenarios. Hence i am asking this question here.