Thank You! Thank You! Thank You! Thank You! Thank You! 

I tried to get onclickSubmit working for a couple of days. I didn't realize that it went inside the navGrid. That's such a great help!

After reading your post, I got it up and running in about 30 minutes

Again, thank you for your help and your patience!

Sloan

it's a little another problem, but it could be also easy solved. You can add in you edit/add options as a parameter of navGrid a function onclickSubmit in your Detail grid. For example,

var grid = jQuery('#master').jqGrid({

...

var urlEditDetail='ColEdit_XML.asp';

var gridDetails = jQuery('#detail').jqGrid({

...

}).navGrid('#ColPager',
                  // navGridOptions:
                  {add:true,edit:true,del:true},
                  // Edit options:
                  {onclickSubmit: function(rp_ge, postdata) {
                       var sel_testcluster_id = grid.getGridParam('selrow');
                       rp_ge.url = urlEditDetail + '/' + sel_testcluster_id;
                   }},
                  // Add options:
                  {onclickSubmit: function(rp_ge, postdata) {
                       var sel_testcluster_id = grid.getGridParam('selrow');
                       rp_ge.url = urlEditDetail + '/' + sel_testcluster_id;
                   }});

So you add onclickSubmit in Edit/Add navigation bar of the Detail grid. If the event take palce, you get Id of from selected row of Master grid and place if either as a part of postdata or in the url like in my example.

Best regards

Oleg

But the problem is that when jqGrid sends the added row to the server, the data has to include the key of the master table row.

For Example:

When jqGrid adds a row, Master_DBName and Master_TableName are blank (as with all the row's fields), so I need to be able to insert the proper key from the master grid/table. Otherwise, the asp file on the server won't know which master record to associate with the detail row.

In other words, I need to populate the fields before the data is sent to the server.

Also, I'll need to get the value(s) of the parent key fields of existing rows in order to figure out the value to put into these parent key fields. I saw an XML example where user data was passed outside the rows, in the same area where things like the page number and such are located. That might be the way to pass the parent key to the grid. (all rows in the detail grid would have the same parent keys).

Sorry to be so slow, and thanks for your patience!

Sloan

I see different ways which can help you. First of all, if new row added send to server, server must returns back at least id. So, you can use one constructed parameter (tdr_ID + '_' + tdr_td_DB). Id will be always sending to server and back and id must be not a part of colModel at all. If tdr_td_DB is nullable, you can use strings like (tdr_ID + '_NULL') in such cases. They will be unique and can be an id. And such constructed Ids can be easy decoded to your real two Ids by server.

Second, if server generates or updates more data fields after data modification, you can use afterSubmit function, which be called by navGrid after Add or Edit action. If one version of such function enough for you in your whole program, you can set with so way:

$.extend($.jgrid.edit, {..., afterSubmit: function(response, postdata) {
            var res = $.secureEvalJSON(response.responseText);
            if (typeof res === "string") {
                postdata.RowVersion = res;
                return [true, ""];
            }
            else {
                postdata.RowVersion = res.RowVersion;
                return [true, "", res.Id];
            }
        }, ...});

or you can set it directly as a parameter of navGrid function:

jQuery(”#ColumnList”).jqGrid({
        url:'ColGrid_XML.asp',
        editurl: 'ColEdit_XML.asp',
        datatype: 'xml',
        mtype: 'POST',

        .....

caption: 'Columns'

    }).navGrid('#ColPager',
                  {add:true,edit:true,del:true,width:'400px'},  // navGridOptions
                  {},   // Edit options
                  {afterSubmit = function(response, postdata) {
                        var res = $.secureEvalJSON(response.responseText);
                        postdata.RowVersion = res.RowVersion;
                        return [true, "", res.Id];
                  }});  // Add options

In the example serever send back to the client JSON encoded data Id and RowVersion (timestamp of data row, which I use for concurency check).  Global version of afterSubmit detects Add or Edit situation based on respond data type. My server send back a string with RowVersion value back for the Edit action and an Object {Id,RowVersion} as a response to Add action. You can solve your problem with a close way.

Regards
Oleg

That helps on edit, but those two fields are empty when a new row is added.

So I still need to find a way to populate them when the form is called, or just after the submit button is clicked on the form.

Thanks!

Sloan

It seems to me, if you'll use "hidden: true, editable: true, editrules: { edithidden: false}" instead of "editable: false,hidden:true", your problem will be solved.

Regards

Oleg

When adding or editing a row, neither field is included in the data sent to the server. Here's the code for the detail table:

The fields tdr_td_DB and tdr_td_Name are the fields that link back to the parent table. I tried adding onClickSubmit, which doesn't seem to ever be called. I've been testing with “alerts” in that code than never show up.

Any help would be greatly appreciated!!

Sloan