title: Oracle APEX: Assign primary key as interactive grid ROWID, Use select Interactive Grid ROWID in SQL query
body: <p>To preface -- I am as green as at gets.</p>
  <p>I am tasked with building an app for internal org use.  We have a DB with patient data, and in interface with a hospital electronic medical records system. patient data entered into the EMR is sent to us via interface to update the patient profile in our database. Partial matches require manual intervention.</p>
  <ol>
  <li>Message is received in a table within a staging schema</li>
  <li>attempts to match to existing patient</li>
  <li>if there are only 'partial matches' a status is set to 'mismatch'</li>
  </ol>
  <p>I want to:</p>
  <ol>
  <li>Display a summary of all 'mismatch' status records. I want to use an interactive grid to select individual records.</li>
  <li>Set ROWID of interactive grid rows to the respective primary key of the record in the staging table.</li>
  <li>Use the selected Interactive Grid ROWID (user selects a specific record in the interactive grid) to select the matching primary key of the corresponding record in staging table to create SQL query to find potential matches within our DB. Potential matches are displayed in a second table.</li>
  </ol>
  <p>Questions:</p>
  <ol>
  <li>How do I set the rowID of an Interactive grid to the unique key column of the staging table?
  --Some research shows I need a hidden item, is this correct?</li>
  <li>How do I access a rowID that has been selected in the Interactive grid to use in a SQL query?</li>
  </ol>
  <p>My humble thanks and appreciation</p>