One  possible solution for your problem IMHO is to close all opened

subgrids and and then to open only one for editing and other operation.

Currently you can not do this. I have make some little changes so

that this can be done and will be available in the next release.

The little piece of code that would resolve your problem can look like this:

var minuses = table.find("img[src$=minus.gif]").each(function() {

$(this).parents("td").eq(0).click();

});

You should call this in subgrid row expanded event, but should wait

until the next release.

Regards

Tony

to use

Foreign Key Index - The key that linkes a master - a foreign key is a referential constraint between two tables. Its the key that makes a master-detail relationship.

Add button... both the master table and the detail table has an add button on the bottom of the grid. The problem is with the detail table (sub grid). The sub grid needs to know the FK of the master table . The subgrid needs to know which row is the master. I am currently doing that by setting the selected row and then getting the value from the selected row. That works until the user clicks on another row.

Barry

Sorry but It is difficult to understand.

What is FK index?

Where is your add button? Where the user click to add  - in master

or in detail?

Regards

Tony

SubGrid as Grid configuration (Master-Detail):

I set the row to selected on expand. When I click add to open the modal add dialog the FK index is correctly set in the Add Form.

Here is a problem. The user can select another row in the master grid. If the user selects another row then the add form dialog wil contain the FK value from the new (currently) selected row.

What the SubGrid needs to know is the ID of the row that caused it to open. Have you considered this? Is there a built in solution?

Thanks!

Barry

That makes sense!. I was thinking that since the row was not selected in the exampe that there might be a way of getting the row if it was not selected.

For my project, in this case, it is correct to select the row. I suppose that in trees expand and select node are distinct operations often. In a grid it probably the case that select on expand is almost always correct.

Thanks for you help on this!

Barry

I suppose you use grid as subgrid

When you open the subgrid in subGridRowExpanded the

second parameter is the id of the row - then

subGridRowExpanded : function (sub_id, row_id) {

...

$("#mygrid").setSelection(row_id);

...

}

This will select your row.

Regards

Tony

beforeShowForm : function(form_id)
{
  jQuery("#ID_1",form_id).attr("value","999");
}

So how do I get the value of ID_1 from the parent row if its not selected?

In the parent grid I have a key column "ID_1". It is a FK of the child grid.

I click on the + button and the child grid and all the fields are correctly displayed.

I am using the navGrid Add button.

I've been reading the forums for hours and haven't found an example. I found comments and instructions for accessing a selected row in the parent grid, but since I clicked on the + button, the parent row is NOT selected.

When the ADD form is created I want to insert the value of ID_1 from the parent row.

I don't know how to access the value from the parent grids row.

I don't know how to set this value in the ADD form.

Thanks