title: Clearing one block before entering query mode in another
body: <p>Before I ask my question, I have to say that the database that I'm working on doesn't have foreign keys, so I can't make master-detail blocks, and because of that I'm using workaround with go_block, clear_block, execute_query and triggers.</p>
  
  <p>I have a form with two blocks. If we presume that the both blocks are filled with info, and that I want to execute query on first one, is there a way to clear the other block before entering query mode?</p>
  
  <pre><code>e.g.
  
  Block1: ID, NAME, SURNAME
  
  Block2: INFO1, INFO2, ..., Id_block1 etc.
  </code></pre>
  
  <p>So, if there is info on both blocks, and I enter the query mode on Block1, whole block clears so I can enter search criteria, but the second block still has the data from the last executed query. Is there a way to clear the data on the second block as well? Once again, I want to clear the data from Block2 when I'm IN ENTER-QUERY MODE on Block1.</p>
  
  <pre><code>Workflow: Enter-query mode Block1, execute-query Block1, NEW-RECORD-INSTANCE trigger activates (where workflow continues), go_block('Block2'), execute_query on Block2 (with where clause Id_block1 = block1.id).
  </code></pre>
  
  <p>I'm using Oracle Forms 10g. I appreciate any help you can provide.</p>