I have built a "Search and Report" data page with several fields available for search added under "Configure Search Fields". Each of the fields has a minimum number of characters and is a "Contains" match. This works perfectly if data is entered in any of them. The problem is that if no data is entered in ANY of the Search Fields it brings back the entire data set. I do not want to make any specific field required, I just one at least one of the Search Fields to have had a value entered to search for. Said another way I want to disallow the "All Blanks" case. Any thoughts? Thanks is Advance... Russ
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
RussellParker
I have built a "Search and Report" data page with several fields available for search added under "Configure Search Fields". Each of the fields has a minimum number of characters and is a "Contains" match. This works perfectly if data is entered in any of them. The problem is that if no data is entered in ANY of the Search Fields it brings back the entire data set. I do not want to make any specific field required, I just one at least one of the Search Fields to have had a value entered to search for. Said another way I want to disallow the "All Blanks" case. Any thoughts? Thanks is Advance... Russ
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.