Create a Key-ListVal trigger on your item that displays the LOV for you. The trigger will pause execution while the LOV is displayed. Once the user has selected a value from the LOV the trigger will continue executing where it left off. This will allow you to set the Master block's WHERE clause based on the value selected from the LOV and allow you to go to the block and execute the query. Your code will look something like the following:
/* Sample Key-ListVal Trigger */ BEGIN List_Values; IF ( :YOUR_BLOCK.YOUR_ITEM IS NOT NULL ) THEN G0_Block('Your_Master_Block'); Execute_Query; END IF; END;
This code sample assumes that you have already set the Default WHERE clause of your Master block and that your Master block has a relationship created between it and your Detail blocks. If you have not set the default where property of your master block, then you will need to set it in the block properties or set it programatically using the Set_Block_Property() built-in.
Hope this helps,