OraFAQ Forum: Forms » How to search on column form6i

Home » Developer & Programmer » Forms » How to search on column form6i (

) 1 Vote

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

How to search on column form6i [message #429486]

Wed, 04 November 2009 03:05

asalam
Messages: 14
Registered: July 2009

Junior Member

hi
i have form6i , the data_entry needs to search while he enter data in specific column (subject column).
for example , when i entry data when i enter subject i want to list contain the same word in database that i wrote so i will know that there is the subject is already exist .
so what can i do to solve this problem

Report message to a moderator

Re: How to search on column form6i [message #432368 is a reply to message #429486]

Mon, 23 November 2009 18:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create a 'record_group' based on this database column, then base an LOV on the 'record_group' and associate the LOV with the forms item. You can specify that the LOV appears automatically, and some time in the future you can also use the LOV to validate the contents of the item.

David

Report message to a moderator

Re: How to search on column form6i [message #432413 is a reply to message #432368]

Tue, 24 November 2009 01:09

asalam
Messages: 14
Registered: July 2009

Junior Member

thank you for replay
i do this , it works but the list firing after saving so
can i check this list during entering data

thank you again

Report message to a moderator

Re: How to search on column form6i [message #432744 is a reply to message #432413]

Thu, 26 November 2009 00:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What do you mean by "list firing after saving so"?

What do you mean by "check"? If you mean validate, then set 'Validate from List' to 'Yes' at the item level.

David

Report message to a moderator

Re: How to search on column form6i [message #433970 is a reply to message #432744]

Sun, 06 December 2009 01:25

asalam
Messages: 14
Registered: July 2009

Junior Member

Hi Divid

thank you very much for replay, when the write any data displayed
like google search

thankx again

Report message to a moderator

Previous Topic:	How to execute query in Enter Query mode programmaticaly?
Next Topic:	Download Forms 4.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 13:32:28 CST 2025