OraFAQ Forum: Forms » LOV- Automatic

Home » Developer & Programmer » Forms » LOV- Automatic

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOV- Automatic [message #177567]

Thu, 15 June 2006 09:05

rfoerst
Messages: 9
Registered: March 2005

Junior Member

I am trying to have the List of Values for a field activated based on a value from another field. If the value in field-A is 'X', then I would like to activate the LOV for field-B programmatically, if the value of field-A is any other value than 'X' then I do not want the LOV for field-B to be displayed automatically.

Thanks
Rick

Report message to a moderator

Re: LOV- Automatic [message #177684 is a reply to message #177567]

Fri, 16 June 2006 01:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create two LOVs for field B, one is 'auto display' and the other is not 'auto display'.

Use the set_item_property 'lov_name' to swap from one to the other depending on whether you want auto display or not.

David

Report message to a moderator

Re: LOV- Automatic [message #197369 is a reply to message #177567]

Wed, 11 October 2006 01:42

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

I am trying to have the List of Values for a field activated based on a value from another field. If the value in field-A is 'X', then I would like to activate the LOV for field-B programmatically, if the value of field-A is any other value than 'X' then I do not want the LOV for field-B to be displayed automatically.

to solve ur problem

try this trigger
on

Key-Next_item

declare

a boolean;

begin

if field-A = 'x' then
a := show_lov('lov_name');
else
next_field;
end if;

end;

Report message to a moderator

Previous Topic:	sending mails
Next Topic:	disable login screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:51:11 CDT 2024