Oracle Forms

Oracle forms 6i
Hai All

I have created a form in that i have four button ADD, QUERY, SAVE ,EXIT.

I have two block named Leader and members.

Four fields in leader block namely name , codeno, deptcode, unitid.

When i pressed query button and the cursor goes to name field in leader when i enter the name of leader and click

enter i gives the codeno, deptcode and unitid of the leader_name.

so now i have created another block in tabular structure to bring the members in the same deptcode that belongs to Leader_name.

So pls tell me the steps how to create the relation between these two blocks.


when i enter the leader_name and gives enter it needs to bring the codeno, deptcode, unitid and

I also need to gives the members in that deptcode..


Thanks In Advance

Srikkanth.M