Home » Developer & Programmer » Forms » Displaying distinct values in LOV
Displaying distinct values in LOV [message #78295] Mon, 11 February 2002 21:27 Go to next message
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...
Re: Displaying distinct values in LOV [message #78302 is a reply to message #78295] Tue, 12 February 2002 06:03 Go to previous message
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);
Previous Topic: how populate a list item with multiple fields?
Next Topic: displaying results again
Goto Forum:
  


Current Time: Fri May 24 23:37:52 CDT 2024