This content has been marked as final. Show 3 replies
994418 wrote:Hi, sekhar.
i am developed a new custom master child form using stacked canvas.Here i am taking two frames with diffrent data blocks.my point is i am enter the value from the lov in first frame automatically execute the second frame data block without button.
fisrtdatablock:dept no(dept table).
second datablock:employee information(emp table).
select the dept value from lov automatically execute the second data block emp information.
can help me any one.
Welcome to the Oracle Forums. Please take a few minutes to review the following:
<li>Oracle Forums FAQ
<li>Before posting on this forum please read
<li>10 Commandments for the OTN Forums Member
<li>How to ask questions the smart way
Following these simple guidelines will ensure you have a positive experience in any forum; not just this one!
Your forms mode isn't clear. Is it in enter-query mode or insert mode.
what can you do ?
use a timer in post-change or when-validate-item trigger at deptno item at first data block. because go_block isn't supported by p-c or w-v-t trigger.
and at when timer expire, write your code to go second block and insert/query the associate date from emp table.
Hope you understand.
If someone's response is helpful or correct, please mark it accordingly.*
994418 wrote:Hi sekhar
hamid exact my requirment is the user select the value from list value of values as dept no,automatically second data block infromation executed.this is my requirment
follow my steps what i said.
If someone's response is helpful or correct, please mark it accordingly.