Topic: Search Button with "Contained Within"
Hello,
I have a database which has a SEARCH button above the TableGrid that uses a couple of drop down Comboxes and it works well as expected. The records have a couple of fields which contain free form text that the user would like to include these in the search. I have tested this and it works fine if the exact text is entered into the search box as it appears in a record or records.
Say a field has 'QWERTY' in it, entering QWERTY into the search field would show relevant records. But the user will not always know the exact text in the database field so is there some way that we can have it so if the user entered for example 'RT' it will show records with 'QWERTY' as a field entry because 'RT' is contained within 'QWERTY'.
With all the search fields the user would like, there are now two Combo Boxes, three free form fields, and two date fields.
Thanks for any ideas,
David