Forms 6i-To show detail block when a button is pressed [message #519666] |
Tue, 16 August 2011 04:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi Gurus!
Is it possible to display the detail block (different canvas) in the master block canvas, but when finished entering data into master block and a button is pressed? And i want to use some conditions in the when-button-pressed trigger. based on that it should show different canvas.
simply speaking, my aim is to use the upper part of the screen to show master block and the lower part for a detail block from the different detail blocks based on condition checked in when-button-pressed trigger.
if yes, please tell me the step-by-step procedure for it.
Thanks in Advance
|
|
|
|
|
Re: Forms 6i-To show detail block when a button is pressed [message #519802 is a reply to message #519780] |
Wed, 17 August 2011 01:41 ![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) |
|
As advised by Mahnazzz, I am attaching the image. The upper part of image (image-1) is the master block and lower part (image-2) is detail block. there are 4 different detail blocks (i have attached one only). I want to show any one detail block on successful satisfaction of the condition given in the "Item Details" push button trigger, which may be like this:
IF :INV_MST.CLASS = 'CPU' THEN
detail block-1
ELSE IF :INV_MST.CLASS = 'MEMORY' THEN
detail block-2
ELSE IF :INV_MST.CLASS = 'HARD DISK' THEN
detail block-3
ELSE
detail block-4
END IF;
END IF;
END IF;
Please guide me, as I am a beginner (5-6 months).
Thanx in advance.
[Updated on: Wed, 17 August 2011 01:43] Report message to a moderator
|
|
|
|
Re: Forms 6i-To show detail block when a button is pressed [message #519857 is a reply to message #519844] |
Wed, 17 August 2011 04:53 ![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) |
|
Thank u very much for your kind and immediate response.
As you said there will b no buttons required, will you plz. guide me how to activate a particular Tab page based on the value of ":INV_MST.CLASS" a text item on master block. Sorry for disturbing u all, if Im wrong, please excuse me as i am a novice in Forms & Reports (just 6-7 months old).
|
|
|
Re: Forms 6i-To show detail block when a button is pressed [message #519874 is a reply to message #519857] |
Wed, 17 August 2011 06:00 ![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 |
|
|
If master-detail relationship is correctly set (Wizard would do that): when you execute a query in a master block, detail block is automatically populated with detail data. You don't have to code anything, just choose a tab you are interested in, and data will be there.
|
|
|