title: Showing parent datatable in one datagridview and show child datatable elements in another?
body: <p>Hi I have created a dataset and two datatables. The URLData table is parented to the KeywordData table via the keyword column.</p>
  
  <pre><code>'Create the primary object to hold both data tables
      Dim AllKeyWordInfo As DataSet = New DataSet("AllKeywordInfo")
  
      'Create a Datatable For keyword Data. Data Tables are stores In the Dataset
      Dim KeywordData As DataTable = AllKeyWordInfo.Tables.Add("Keywords")
  
      'Create a Datatable For URL Data.
      Dim URLData As DataTable = AllKeyWordInfo.Tables.Add("URLMetrics")
  
      'Add Columns to our Keyword datatable
      KeywordData.Columns.Add("Keyword")
      KeywordData.Columns.Add("SearchCount")
  
      'Add Columns to URLDATA
      URLData.Columns.Add("Keyword")
      URLData.Columns.Add("URL")
      URLData.Columns.Add("DA")
      URLData.Columns.Add("PA")
  
      'Creat a parent child relationship
      AllKeyWordInfo.Relations.Add("ALLDATA", AllKeyWordInfo.Tables("Keywords").Columns("Keyword"), AllKeyWordInfo.Tables("URLMetrics").Columns("Keyword"))
  
      'parent
      KeywordData.Rows.Add("TESTEST", "1123829")
  
      'children 
      URLData.Rows.Add("TESTEST", "288789")
      URLData.Rows.Add("TESTEST", "asdsdsdd")
  
  
      DataGridView1.DataSource = KeywordData
      DataGridView2.DataSource = URLData
  </code></pre>
  
  <p>What I would like to do is show everything from the KeywordData table in datagridview1. When a user click on any row (full row select enabled on the datagrid) I would like datagridview2 to show all the child rows for that keyword. Any time the user switches rows in datagridview1 it switches to the proper child rows in datagridview2. Is this possible?</p>