oracle - Clearing one block before entering query mode in another -

oracle - Clearing one block before entering query mode in another -

before inquire question, have database i'm working on doesn't have foreign keys, can't create master-detail blocks, , because of i'm using workaround go_block, clear_block, execute_query , triggers.

i have form 2 blocks. if presume both blocks filled info, , want execute query on first one, there way clear other block before entering query mode?

e.g. block1: id, name, surname block2: info1, info2, ..., id_block1 etc.

so, if there info on both blocks, , come in query mode on block1, whole block clears can come in search criteria, sec block still has info lastly executed query. there way clear info on sec block well? 1 time again, want clear info block2 when i'm in enter-query mode on block1.

workflow: enter-query mode block1, execute-query block1, new-record-instance trigger activates (where workflow continues), go_block('block2'), execute_query on block2 (with clause id_block1 = block1.id).

i'm using oracle forms 10g. appreciate help can provide.

it possible create master-detail relationship while creating 1 of blocks in form or can write next on key-entqry trigger :

go_block('block2'); clear_block; go_block('block1'); enter_query;

after this, block1 in enter-query mode , can search info , execute block.

oracle plsql oracle10g oracleforms