LOV help [message #487031] |
Wed, 22 December 2010 01:29 |
swapnil_naik
Messages: 269 Registered: December 2009 Location: Mumbai
|
Senior Member |
|
|
Hi friend, i want to know is it possible or not ?? i did it but i didnt get the result what i want
I created a lov ....
Lov :- Select empno, ename, job , hiredate, sal from emp
If i am searching thru empno and selected record to that empno...data is properly dispalyed on form...
But if i am serching thru ename, i did not get proper data in lov...
it means i want to search this lov by using ename, job etc. not only empno...
how to do this ??
Thanks in advance...
|
|
|
Re: LOV help [message #487050 is a reply to message #487031] |
Wed, 22 December 2010 04:10 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
LOV's are desinged to search on the first column in their select list only.
To search on multiple fields you need multiple LOVs.
Or write a form that acts like an LOV and call that from the key-listval trigger (and when-validate-item if you want to mimic validate from list).
|
|
|