I have a table that has a foreign key to another table, and I would like to provide a dropdownlist as the editor for the foreign key field and then save the object back to the database using oData.
I can get the grid to create just fine, and CRUD operations work great on the main set of data.
This leaves with me a couple of options.
I can simply bind the column to the foreign key field int field, and use a custom editor to create the dropdownlist to provide the id from the lookup table on, but leaves me displaying a simple int in the grid instead of a more meaningfull property of the lookup table.
Or I can use the $expand in the Read of the DataSource, include a field bound to the more meaningfull property, but can't get the editor to work quite right or the Update postback to work.
I have made some fiddles to try to show my point.
http://jsfiddle.net/giltnerj0/h4wx5/
http://jsfiddle.net/giltnerj0/h4wx5/1/
(These won't work for actual CRUD operations due to the JSONP from using demos.kendoui.com as the service)