Tech Off Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

3 Tiered Data grids? 3 levels of details?

Back to Forum: Tech Off
  • User profile image

    I have a listbox and 2 data grids. The listbox and 1st datagrid work good in master/detail mode using a relationship in the dataset. I also have a relationship between tables 2 and 3, and would like the selection in datagrid 2 to update datagrid 3. How can I do this?

    listbox1.datasource = dataset
    listbox1.displaymember = "Table1.Field1"

    (datagrid2) 'Should show data in table 2 based on what is selected in listbox1
    datagrid2.datasource = dataset
    datagrid2.datamemeber = "Table1.Relation1"

    (datagrid3) 'Should show data in table 3 based on what is selected in datagrid2
    datagrid3.datasource = dataset?
    datagrid2.datamemeber = "Table2.Relation2"?

    So datagrid3 does not update as I select fields in datagrid2. What is the corret way to do this?

  • User profile image

    It's this:
    datagrid2.datamember = "Table1.Relation1.Relation2"

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.