OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » lov (form 6i, oracle8i)

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

lov [message #289595]

Mon, 24 December 2007 03:57

jitender.sadh
Messages: 86
Registered: May 2007

Member

hi

i have a requirement in which i have two text item's exist on different canvas's and i have a single column lov in the form.
i want to invoke the lov for both text items form the button items which are placed near the text items and return the slected value from the lov to the text item's.

regards
jitender.

Report message to a moderator

Re: lov [message #289608 is a reply to message #289595]

Mon, 24 December 2007 05:05

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You can use the same record group; just create two LoV's and base them on this record group. Make sure every LoV returns value into appropriate text item (i.e. create a proper mapping between LoV value and form item).

Report message to a moderator

Re: lov [message #289757 is a reply to message #289608]

Wed, 26 December 2007 01:06

jitender.sadh
Messages: 86
Registered: May 2007

Member

hi
is there any other method in which i user single lov to accomplish that task.

regards
jitender.

Report message to a moderator

Re: lov [message #291364 is a reply to message #289757]

Fri, 04 January 2008 00:29

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

Senior Member
Account Moderator

Another Orafaq poster recommended using either a 'global' or a hidden field in a 'control' block as the receiving field in the LOV and then copying that value to the field in which you are currently interested.

David

Report message to a moderator

Re: lov [message #291463 is a reply to message #291364]

Fri, 04 January 2008 05:21

jitender.sadh
Messages: 86
Registered: May 2007

Member

ok, but by this method i can only provide same value to both items , but i want to provide different values to both the items.

regards
jitender

Report message to a moderator

Re: lov [message #292381 is a reply to message #291463]

Tue, 08 January 2008 18:31

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

Senior Member
Account Moderator

Forms can only process one item at a time. Therefore, if, in the LOV trigger associated with each item, you take the returned value and place it in your record then each trigger associated with its own item may place the returned information in different places.

David

Report message to a moderator

Previous Topic:	Can we develop form from View? and How to Develop Form based on the view? (merged - djmartin)
Next Topic:	Error 408

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 07 15:04:47 CDT 2025