title: Selecting two other datagridview rows after selecting first, related on 'rptId' field
body: <p>I have three datagridviews in a windows form, and want to be able to automatically have the two other datagridviews to select their respective rows, based on a rptID column value.<br>
  All three datagridviews are different sql tables, related by the rptID.  </p>
  
  <p>I have been able to pull the rptID from all three dgv's within a click event with this code:</p>
  
  <pre><code>private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
          {
              int rptIdValue1 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString());   
          }
  </code></pre>
  
  <p>My problem is figuring out how, with this rptID value, to compare it to the two other dgv's, and select the corresponding dgv row (i.e. Click rptId 51 and then auto-select the corresponding rptID rows in the two other dgv's).</p>
  
  <p>I appreciate any help that is given. I tried to post a pic of my form, but don't have enough rep point.</p>