OraFAQ Forum: Forms » Displaying distinct values in LOV

Home » Developer & Programmer » Forms » Displaying distinct values in LOV

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

Displaying distinct values in LOV [message #78295]

Mon, 11 February 2002 21:27

Lokesh Kumar
Messages: 1
Registered: February 2002

Junior Member

Case: Multi Record design
Column: Deptno
Table: emp
LOV Table: Dept
Column Dept in emp form has an LOV.
The table emp contains no record.
I insert the first record.
I select dept 10 from lov.
I save the record. save success.
I enter the second record in emp table
The LOV should not show dept 10 in lov!!!!
What should i do to eliminate this dept...
I save the 2nd record in emp for dept 20
The LOV should not show dept 10,20 in lov!!!!
What should i do to eliminate this dept...

Report message to a moderator

Re: Displaying distinct values in LOV [message #78302 is a reply to message #78295]

Tue, 12 February 2002 06:03

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

change the lov query(dept) like this

select deptno from dept
where deptno not in (select deptno from emp);

Report message to a moderator

Previous Topic:	how populate a list item with multiple fields?
Next Topic:	displaying results again

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 00:16:51 CDT 2024