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


strucure of form like this


Master(tfl_master)
---------------------------------------------------
headcode ,,, amount ,, revamount
----------------------------------------------------
business 10,000 +500.
capital 20,000





child
----------------------------------------------------
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
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
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.

David
Previous Topic: get SQL statement in error (shift+F1)
Next Topic: Message not getting displayed in 10gR2
Goto Forum:
  


Current Time: Mon Nov 11 01:28:02 CST 2024