OraFAQ Forum: Forms » Lov for Multiple items

Home » Developer & Programmer » Forms » Lov for Multiple items

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

Lov for Multiple items [message #80392]

Tue, 17 September 2002 00:38

Sameer
Messages: 60
Registered: March 1998

Member

How can u use same LOV for multiple items in the form

Report message to a moderator

Re: Lov for Multiple items [message #80424 is a reply to message #80392]

Thu, 19 September 2002 00:21

Susane
Messages: 27
Registered: September 2002

Junior Member

hi!

you can use same LOV in multiple items just set the properties of item to that LOV but when you are using same LOV but you have to filter your LOV by your inputs i thinks u can't.

Report message to a moderator

Re: Lov for Multiple items [message #80429 is a reply to message #80424]

Thu, 19 September 2002 09:05

Sameer
Messages: 60
Registered: March 1998

Member

I got the solution In lov instead of lookup fields as the block fields u give something as global.itemname or parameter.itemname.Then in the show_lov u can use by checkin which item is currently havin cursor and assign the global or parameter value to the field accordingly.

Report message to a moderator

Re: Lov for Multiple items [message #80433 is a reply to message #80424]

Thu, 19 September 2002 14:47

Susane
Messages: 27
Registered: September 2002

Junior Member

can u share with me how u used the global variables to use this in the parameter of your LOV. Did you used it in your record groups. How u put value in the global and how you used it in your LOV. Please share because that's the great idea.

thanks

Report message to a moderator

Re: Lov for Multiple items [message #80443 is a reply to message #80424]

Fri, 20 September 2002 22:23

sameer_am2002
Messages: 129
Registered: September 2002

Senior Member

Susane can u give ur email address so that i can mail u the fmb file for LOV for multiple items

Report message to a moderator

Re: Lov for Multiple items [message #676795 is a reply to message #80443]

Tue, 16 July 2019 11:22

nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore

Junior Member

can anyone share the solution please

[Updated on: Tue, 16 July 2019 11:23]

Report message to a moderator

Re: Lov for Multiple items [message #676798 is a reply to message #676795]

Wed, 17 July 2019 02:01

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

Senior Member
Account Moderator

Which "solution", exactly? If you open item's Property Palette, there's the LoV section - put that LoV's name into it, and it (the LoV) will be used for all those items.

Report message to a moderator

Re: Lov for Multiple items [message #676800 is a reply to message #676798]

Wed, 17 July 2019 08:50

nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore

Junior Member

Thanks you for your valuable time littlefoot.

1.I was expecting a solution for creating one lov for multiple items.
2.It seems it's possible with global variable(Instead of returning the value from lov directly to the block item , return it to global variable).
3.However based on the current/cursor record show the LOV and get return value into global variable and then pass it to the database block item to save into the database.
4. I did 3-4 years back but i forgot now...

Thanks you once again @Littlefoot for helping each and every member with your skills

Report message to a moderator

Re: Lov for Multiple items [message #676801 is a reply to message #676800]

Wed, 17 July 2019 10:26

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

So you want identical looking LOVs that are attached to different items?
I'd just create multiple LOVs, it'll be simpler, you can use the same record group for all of them.

Report message to a moderator

Previous Topic:	Image on the form for splash screen
Next Topic:	Scrolling up the query data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 03:59:47 CDT 2025