I have made 2 views (copy) of a table with some data - and would like to perform a search on this.
I have made 2 screen types, one with a filter form and one with a Search form at the top, both have a grid below.
The filter works well. In Subjects i’ve checked ‘Start empty with filter’, so this prevents (I assume..) the loading of the 1000’s of records that are not needed. I filter on a number, and it shows the corresponding lines.
In filter, I expect to load all records, and search for the value, but the button ‘Search’ appears to be dead. Anything I need to check to get this working? What did i miss?
Also, can anyone tell me the difference between a Search and a Filter?
Filter - hides all non-matching values I suspect (but they are there in the background)
Search - ?
Trying to figure this out to assure some efficiency.
Thanks for the input!