Home » Developer & Programmer » Forms » How to use same LOV for 2 columns? (Oracle Form 6i)
How to use same LOV for 2 columns? [message #351019] Mon, 29 September 2008 00:47 Go to next message
hiteshkanjaria
Messages: 8
Registered: September 2008
Junior Member
Hi,

I have created a LOV for the column costcode but I want to use the same LOV for another column respcode column, so how can I achieve the same?
Re: How to use same LOV for 2 columns? [message #351022 is a reply to message #351019] Mon, 29 September 2008 00:59 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

What harm will be done if you have 2 LOV's?
Re: How to use same LOV for 2 columns? [message #351027 is a reply to message #351019] Mon, 29 September 2008 01:12 Go to previous messageGo to next message
hiteshkanjaria
Messages: 8
Registered: September 2008
Junior Member
If there is any solution then why should we have to use two LOV for the same? I may be more that two place where we need u use same lov.
Re: How to use same LOV for 2 columns? [message #351033 is a reply to message #351027] Mon, 29 September 2008 01:17 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No. One LOV per set of returned items. They can share the same 'record_group'.

David
Re: How to use same LOV for 2 columns? [message #351036 is a reply to message #351019] Mon, 29 September 2008 01:21 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Do you mean the same LOV or the same record group?
You can use 2 LOVs built on the same record group. Normally, the two LOVs will have different return values (different assignments to your fields).

Rajy
Re: How to use same LOV for 2 columns? [message #351039 is a reply to message #351019] Mon, 29 September 2008 01:31 Go to previous message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
@David

Sorry, I didn't see your post.
It seems you posted it while I was writing mine.

Rajy
Previous Topic: inserting values in non query record group
Next Topic: sending of paramters to a called form and to receive it in call ed form
Goto Forum:
  


Current Time: Thu Dec 08 16:15:57 CST 2016

Total time taken to generate the page: 0.10575 seconds