Members   Search   Help    Register    Login   Home
Home » Developer & Programmer » Forms » How to search on column form6i  () 1 Vote
How to search on column form6i [message #429486] Wed, 04 November 2009 03:05 Go to next message
asalam
Messages: 10
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 Go to previous messageGo to next message
djmartin
Messages: 9452
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
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 Go to previous messageGo to next message
asalam
Messages: 10
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 Go to previous message
djmartin
Messages: 9452
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
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
Previous Topic:DDE Package. How to close a excel file without saving changes and without messages
Next Topic:Mod and Remainder Numaric function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 20:45:02 CST 2009

Total time taken to generate the page: 0.01063 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.