// LOOKUP A COLUMN VALUE IN THE TABLE REFERENCED BY THE FOREIGN KEY
    private void lookupColumnValueDGV( object sender, EventArgs e ) {
      ToolStripItem menuItem = ( ToolStripItem ) sender;
      rowInfo info = ( rowInfo ) menuItem.Tag;
      string[] sColInfo = info.relation;
      DgvFormJIT df = new DgvFormJIT( this,
                                      sConnDb,
                                      sColInfo[PARENT_SCHEMA],
                                      sColInfo[PARENT_TABLE],
                                      sColInfo[PARENT_KEY],
                                      info.dgv.Rows[info.row].Cells[info.relation[CHILD_KEY]].Value.ToString(),
                                      info.rect
                                    );
      if ( df.SelectedValue != "" ) {
        info.dgv.Rows[info.row].Cells[info.relation[CHILD_KEY]].Value = ( object ) df.SelectedValue;
      }
    }

Last updated 13 Apr 2020