OraFAQ Forum: Forms » Copy values from header to line in multiblock records

Home » Developer & Programmer » Forms » Copy values from header to line in multiblock records (d2k)

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

Copy values from header to line in multiblock records [message #305806]

Wed, 12 March 2008 01:32

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

Hi,
I have master record at header and in lines i hv detailed multi record block.
I want the project name value from header to be copied to all record in line level.
how to do this?

Report message to a moderator

Re: Copy values from header to line in multiblock records [message #305808 is a reply to message #305806]

Wed, 12 March 2008 01:44

akramrabaya
Messages: 41
Registered: November 2007

Member

if i correctly understood your requirements

add a new filed on your detailed multi record block and let it be
:project_name and in the properties of this filed set
copy value from as :master.project_name

akram

Report message to a moderator

Re: Copy values from header to line in multiblock records [message #305946 is a reply to message #305808]

Wed, 12 March 2008 06:39

Flash
Messages: 34
Registered: February 2008

Member

one more workaround.

Set the initial value of the child items to that of master items.

Thanks
Flash

Report message to a moderator

Re: Copy values from header to line in multiblock records [message #306374 is a reply to message #305806]

Thu, 13 March 2008 23:57

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

Thanks a lot,
actually i tried that one but it wasnt working.

so i run a loop in line blck that whenever user changes value in header, it will run a loop with exit condition as "exit when :system.last_record='true'" and assigned values.
its working fine.

thanks for your help.

Report message to a moderator

Previous Topic:	Help plss Should a cursor be created in database or program unit in forms like in a package
Next Topic:	how to join more than three tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 21:57:49 CDT 2025