I want to do following (how to create a form like this) [message #641562] |
Tue, 18 August 2015 03:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Dear Members,
I have two Tables (Master and Detail) in database. In form level I have separated Detail table into two blocks and want to do the following.
please let me provide solution to do this. I use relationship using join condition but only one record in third detail block is inserted
Regards,
Usman
[MERGED by LF]
-
Attachment: PROBLEM1.JPG
(Size: 59.54KB, Downloaded 1158 times)
[Updated on: Wed, 19 August 2015 00:14] by Moderator Report message to a moderator
|
|
|
Re: I want to do following [message #641581 is a reply to message #641562] |
Tue, 18 August 2015 08:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6f539f43889b4b3e3fcb6c591073de8f?s=64&d=mm&r=g) |
CraigB
Messages: 386 Registered: August 2014 Location: Utah, USA
|
Senior Member |
|
|
Quote:In form level I have separated Detail table into two blocks and want to do the following.
Do "What" following? You don't give any details about what you are trying to do? Based solely on the attached image, it appears you have more items to display than you have "Width" of your canvas to hold, so you have stacked the items above and below each other. I think you would be better off only having 1 Detail data block, instead of 2, and simply arrange the items so they are stacked - like in your attached image file. By having 2 separate Data Blocks based on the same table, Forms will attempt to perform DML on both instances of the table. This could be the reason the data in one of the detail blocks is the only one being saved.
As to copying values from the Master block to the Detail block, take a look at the "Copy Value from Item" property of your Detail Block item.
I hope this helps, but to be honest, we need more information about how you have your Form configured in order to give you a better answer.
Craig...
|
|
|
Re: I want to do following [message #641593 is a reply to message #641581] |
Tue, 18 August 2015 22:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Thanks Dear CraigB for you keen help. I'm really very sorry for incomplete information. However, detailed problem have clearly been described in new topic created today for your review and help please.
Regards,
Usman
Pakistan
|
|
|
How to create form Like this [message #641594 is a reply to message #641562] |
Tue, 18 August 2015 23:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Respected Members Junior / Seniors,
I would like to create form like as shown below:
![http://s30.postimg.org/a6q8fgndd/PROBLEM5.jpg](http://s30.postimg.org/a6q8fgndd/PROBLEM5.jpg)
It looks like simple Master / Detail Form but I would like to create logic behind it that, when user enter data in this form (Cash Code in Master) and (Ac Code, Narration & Amount in Detail) then data inserted in database table should be as give below:
![http://s15.postimg.org/6zpmey5aj/DATABASE.jpg](http://s15.postimg.org/6zpmey5aj/DATABASE.jpg)
Please let me help in the matter.
Regards,
Muhammad usman
|
|
|
|
|
|
|
|
|
|
Re: How to create form Like this [message #641721 is a reply to message #641610] |
Fri, 21 August 2015 00:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
I've inserted two records in database successfully using Post Insert trigger but when would I execute query in form it shows all the record in the table where master transaction code = detail transaction code
But I would like to show record as inserted. Please let me guide in the matter.
[Updated on: Fri, 21 August 2015 00:36] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: How to create form Like this [message #641738 is a reply to message #641737] |
Fri, 21 August 2015 04:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You can't (as I already told you). Those detail records' ACC doesn't match master record's ACC and can't be displayed in a master-detail form which has that relationship correctly set.
Think it over: what is the purpose of a master-detail form if you want to display - in the detail block - records that don't match its master? It just doesn't make sense.
|
|
|