master detail sub-detail not updating on row click

[ewillyb]

I have a strongly-typed DataSet with 3 DataTables related to one
another such that there is a 1-many between master and detail and
1-many between detail and sub-detail.

The DataSet is bound to 3 DataGrids -- 1 DataTable per Grid. I bound
like this:

gridMaster.DataSource = dataset
gridMaster.Member = "tableMaster"

gridDetail.DataSource = dataset
gridDetail.Member = "tableMaster.relateMasterToDetail"

gridSubDetail.DataSource = dataset
gridSubDetail.Member = "tableMaster.relateDetailToSubDetail"

The DataTables are populating with the correct information from the
database.

Here is the problem:
The Sub-detail grid does not refresh with the correct records when the
selected rows of the Master and Detail change. Changing rows in the
Master grid DOES change the Detail grid to show only those rows that
share an ID with the Master grid's current row. However, the
sub-detail does not change to show the records related to the new ID
selected in the Master and Detail grids.

Would greatly appreciate any help on this.
Thx.

 

[Andy]

On 23 Sep 2003 15:10:40 -0700, (e-mail address removed) (ewillyb) wrote:

I had a similar problem and someone answered, here's what I think you
need to do:

gridSubDetail.Member =
"tableMaster.relateMasterToDetail.relateDetailToSubDetail"