I have my jqGrid setup for inline editing. Each of these columns performs a dataUrl in the editoptions param.
Column A is a standard lookup, however the remaining columns depend on the select:value of column A. Right now I am using beforeEditCell to capture the rowID of the selected/edited row and I call $.getJSON and pass that rowID to my controller to identify the value of Column A and then perform the lookup for Columns B, C, D, E, F depending on what column's cell the user is trying to edit.
Is there a better way to do this? Perhaps a way when a user goes to edit a cell I can tell the grid to get the value of Column A and pass that to the lookup call?
Yes, I understand that. However in the dataEvent, I would have to pass the value of ColumnA into the dataEvent for columnB so that my results from that dataEvent would be filtered based on the value of ColumnA.
This was pretty critical and I had to abandon this. Right now I limit the grid display to a specific ColumnA value so that all my other lookup columns can already know what the id of my old ColumnA.
Thanks for your help Tony. We ended up modifying the way the grid on this page is displayed and auto-setting a filter for ColumnA, that way all the other columns will know to load only the data related to the value for ColumnA.