OraFAQ Forum: Forms » master child relation for non control blocks

Home » Developer & Programmer » Forms » master child relation for non control blocks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master child relation for non control blocks [message #515075]

Fri, 08 July 2011 01:09

goparaju
Messages: 54
Registered: June 2011

Member

Hi Experts,

I am working on form builder 6i. I have a header block A(Multi record block), child block B. Both are non control blocks. My requirement is, if i put the cursor in any header record, i want to auto populate corresponding child record like in master child relation.

Could somebody help me in which trigger i need to write logic to auto populate the child record.

Kindly help.

It's urgent requirement.

Thanks in advance.

Report message to a moderator

Re: master child relation for non control blocks [message #515093 is a reply to message #515075]

Fri, 08 July 2011 01:54

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

If they're both non-control blocks that would mean they're both database blocks. In which case the correct thing to do is create a relationship between them and let forms do all the work.

Report message to a moderator

Re: master child relation for non control blocks [message #515127 is a reply to message #515093]

Fri, 08 July 2011 03:13

goparaju
Messages: 54
Registered: June 2011

Member

HI,

Thanks for your reply.I typed it wrong, both are non database blocks(control blocks). Kindly help me how to auto populate data in line section if i put the cursor in header section like in master detail relation between database blocks.

Thanks in advance.

Report message to a moderator

Re: master child relation for non control blocks [message #515156 is a reply to message #515127]

Fri, 08 July 2011 05:29

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In a loop, record by record. But that's a tedious job.

Can't you just create an ordinary master-detail relationship between database blocks? What prevents you to do that?

Report message to a moderator

Re: master child relation for non control blocks [message #515176 is a reply to message #515156]

Fri, 08 July 2011 06:53

goparaju
Messages: 54
Registered: June 2011

Member

Hi,

Thanks for your reply. In my header block, data will come from FIND window search. Header block is not a database block as well as child block also.

So i can't create master detail relation. Could you suggest me any alternative which works in similar manner.

Kindly help.

Thanks.

Report message to a moderator

Previous Topic:	Error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Next Topic:	update table data via oracle forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 21:29:57 CDT 2024