Home » Developer & Programmer » Forms » i want to find the record in the LOV with any one of the field
i want to find the record in the LOV with any one of the field [message #177642] Thu, 15 June 2006 23:59 Go to next message
ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad
Junior Member
hi
i have one fomr module in that i created a lov .the fields in the lov are(code,name,state,country).
i want to search the record in the lov withrespect to any one of the above mentioned fields not with only first column.

it is very urgent pls send me the replay as soon as possible

the query in the LOv is "select name,code,state,country from cuty order by name".

THE table fields are
CODE NOTNULL
NAME
STATE
COUNTRY
Re: i want to find the record in the LOV with any one of the field [message #177659 is a reply to message #177642] Fri, 16 June 2006 00:54 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You cannot do that with a default LOV. In such case, you can create your own simple form with enhanced query functionality.

MHE
Previous Topic: Tunning Through Forms
Next Topic: email code
Goto Forum:
  


Current Time: Fri Sep 20 09:48:27 CDT 2024