Help on a Query

I'm trying to execute a query for two blocks in the same canvas but it's not working. The relation between the blocks are fine. When I run the query it only gets the data for the master block.
Any help would be most welcomed.
Thanks.

Have you written your own query or using oracle predefined button to enter or execute query?

(1) if you are using oracle predefined button then look at the block level procedure 'ON-POPULATE-DETAILS' in master block, this procedure is created by developer when you create relationship. For example i have created a form based on DEPT as master block and EMP as detailed block but whenever i click on execute query button it does not show the child/detaile records. I make the follwoing changes in this procedure.

IF (( EPT.DEPTNO IS NOT NULL)) THEN
rel_id := Find_Relation('DEPT.DEPT_EMP'); //define your relation name here
Query_Mater_details(rel_id,'EMP'); //write the name of your detail block
END IF;

Make sure that Query_Master_Details procedure is exist in program unit. if you dont find these procedure then create relationship again.

(2)If you have written your on query then after fetching the values of master record add the following lines:

go_block('EMP');
execute_query.


Regards

Thanks for the help!!!!!