| automatic display of LOV [message #82371] |
Thu, 22 May 2003 08:44  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
|
I have 2 LOV's (say LOV1 and LOV2) in 2 different Blocks (say BLOCK1 and BLOCK2) in the same tab. I want to display LOV2 as soon as the user hits the 'OK' button in LOV1. (This will save them a key-stroke). Can anyone tell me how to do this? Thanks in advance.
|
|
|
|
| Re: automatic display of LOV [message #82372 is a reply to message #82371] |
Thu, 22 May 2003 09:16  |
Ani
Messages: 56
Registered: November 2000
|
Member |
|
|
Hi,
try this.In key-next of the text item
enter;
if form_success then
declare
a boolean;
b boolean;
begin
if :txt1 is not null then
a:=show_lov('lov1');
if not a then
message('no records in LOV1');
raise form_trigger_failure;
end if;
--On success of LOV1 the next lov is displayed
b:=show_lov('lov2');
end if;
end;
end if;
The above code will help u 2 to show both the lov's. i.e as soon as u click enter in the text item 1st lov will b displayed. On ok,it will display lov2.
Try this and get back to me. All the best.
Bye
Ani
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
