Home » Developer & Programmer » Forms » master detail relation
master detail relation [message #286847] Mon, 10 December 2007 04:25 Go to next message
Messages: 8
Registered: September 2007
Karma: 0
Junior Member
iam having difficulty problem with master details relation

strucure of form like this

headcode ,,, amount ,, revamount
business 10,000 +500.
capital 20,000

headcode subcode amount
business businessloss -500
business businessgain 1000

capital capitalloss -200
capital capitalgain 500

this businesscode and amount we are getting form trigger

when new block instance trigger(using cursor)

here if i click headcode it has to going to chikd block
and giving child details (we willsee above for first record that is businee.)
and then child amount shold reflected to rev amount column in master.
now if we move to second master record it is (capital )clearing previous business record and it enterring second child.

ok till now its fine
now the problem is if again move to first master that is business that previous child records of business in not coming .it has to come that previous detils and then we can able to add one record to that business child.

thsi is my requirement

can any one give me suggestion and its challanging to me

[Updated on: Mon, 10 December 2007 04:26]

Report message to a moderator

Re: master detail relation [message #288902 is a reply to message #286847] Wed, 19 December 2007 00:45 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Karma: 0
Senior Member
Account Moderator
Have you solved your problem? If not, consider starting a new form, use the default wizards to create the blocks and the 'relations' between the two blocks. Then start adding your own code.

Previous Topic: Killing of user sessions in oracle
Next Topic: list problem while calling report from froms
Goto Forum:

Current Time: Tue Aug 22 13:53:04 CDT 2017

Total time taken to generate the page: 0.06344 seconds