| Please help [message #173574] |
Tue, 23 May 2006 04:24  |
prase_pk
Messages: 40
Registered: July 2005
Location: india
|
Member |
|
|
I am using oracle forms 4.5.This is one scenario.
I have a text item ITEM1 in a block and some more text fields ITEM2 and ITEM3 in the same block.It is a non database block.
When I select a value from the LOV for ITEM1, how will I automatically display values into the other items.I mean is there any direct trigger for that.
I have used when-validate-item trigger for this purpose.
But its getting fired when the focus moves to any other item.
The second scenario is like this.
For the same form above I have another block(multi-record block) with items dependent on the ITEM1.So the values in this block are dependent on ITEM1.
As I have said above I am using when-validate-item for this also.
But Go_BLOCK does not work in when-validate-item.I cant use key-next-item since the user may go into any it after he enters something in ITEM1.
By the way the user enters the value in ITEM1 to insert into a table.
Please help.
|
|
|
|
| Re: Please help [message #173609 is a reply to message #173574] |
Tue, 23 May 2006 07:46  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Scenario one. You can have many columns in the record_group and LOV. To suppress them being displayed make the column zero characters wide. In the LOV your can define the item into which each column is to be placed.
Try Key-Listval with a Show_LOV and then a go_item.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
