master detail relation [message #286847] |
Mon, 10 December 2007 04:25 |
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 |
|
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
|
|
|