OraFAQ Forum: Forms » How to use same LOV for 2 columns?

Home » Developer & Programmer » Forms » How to use same LOV for 2 columns? (Oracle Form 6i)

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

How to use same LOV for 2 columns? [message #351019]

Mon, 29 September 2008 00:47

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?

Report message to a moderator

Re: How to use same LOV for 2 columns? [message #351022 is a reply to message #351019]

Mon, 29 September 2008 00:59

mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait

Senior Member

What harm will be done if you have 2 LOV's?

Report message to a moderator

Re: How to use same LOV for 2 columns? [message #351027 is a reply to message #351019]

Mon, 29 September 2008 01:12

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.

Report message to a moderator

Re: How to use same LOV for 2 columns? [message #351033 is a reply to message #351027]

Mon, 29 September 2008 01:17

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

Senior Member
Account Moderator

No. One LOV per set of returned items. They can share the same 'record_group'.

David

Report message to a moderator

Re: How to use same LOV for 2 columns? [message #351036 is a reply to message #351019]

Mon, 29 September 2008 01:21

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

Report message to a moderator

Re: How to use same LOV for 2 columns? [message #351039 is a reply to message #351019]

Mon, 29 September 2008 01:31

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 10:15:24 CDT 2026