In a screen [frmWindow], open the search dialog, enter a value for any column and hit search. When clicked on search, I need to format the value given and use this formatted value to populate the screen.
For example: In Customer Order screen, I enter value for Customer as “ABC” and hit search. But in the background, I need to format the “ABC” as “%ABC%” and search for this.
We can achieve this using Saved Search but I need to implement it in the form level. I found QueryWhereStatementFormat but came to know that this can be used only for child sources.
Any suggestions?
