Home » Developer & Programmer » Forms » With bring full name with 3 initial letters
With bring full name with 3 initial letters [message #82835] Tue, 08 July 2003 11:54 Go to next message
Anju
Messages: 33
Registered: September 2000
Member
HI friends,
In my forms what I have to do is if user types initial 3 letters of company name or whatever then it should bring all company name matches with that three letters.
Suppose company name is computer dept. ltd, communication ltd. etc, so when user types “com” in the company_name field then it should bring up both company name or if there is one company with that initial then that company name.
Urgently in need of help!
Thanks in advance.
Anju
Re: With bring full name with 3 initial letters [message #82838 is a reply to message #82835] Tue, 08 July 2003 13:45 Go to previous messageGo to next message
Julie
Messages: 98
Registered: February 2002
Member
If you put a lov on the field, and set it to validate to list, and they type 3 characters and then tab, this functionality will happen automatically.
Re: With bring full name with 3 initial letters [message #82841 is a reply to message #82835] Tue, 08 July 2003 23:18 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
U can write in key next item - execute query;

and in pre query - u can write default where clause

and u can proceed..

I have not tried.. but u can try..
Re: With bring full name with 3 initial letters [message #82859 is a reply to message #82838] Wed, 09 July 2003 22:59 Go to previous message
Anju
Messages: 33
Registered: September 2000
Member
Thanks, it worked.
Anju
Previous Topic: Cursor restriction...
Next Topic: Forms 5 runtime gives GPF (DrWatson)
Goto Forum:
  


Current Time: Sat Mar 02 19:44:45 CST 2024