Filter Button
Previous  Top  Next


The Filter button provides the ability to restrict the display of records in the grid based on the current viewing order (it can be somewhat slow because it adjusts the contents of the grid). It can be selected by:  

·Clicking the button with the left mouse button, or  
·Pressing, and holding down, the <CTRL> key and pressing the <L> key (the underlined letter), or  
·Selecting Edit on the Menu Bar, then selecting Filter Records  

Doing any of the above displays the following dialog box.  

filter  

Entering just a character or two is usually more than enough. If the rows exist, the grid will be adjusted to display only those rows.  
 
noteSetting a filter DOES NOT DELETE ANY RECORDS. It merely restricts the display of records in the grid until the filter is cleared or changed to something else.  

noteThe filter uses the index for the current viewing order.  
 
So, if records are being last name (for example), setting the filter to "C" (omit the quote marks) would display only those records whose last name begins with the letter "C" (i.e., names such as Adams, Barker, Hoover, Jenkins, and Williams, etc. would not be displayed in the grid). Setting the filter to "CR", would further restrict the display by omitting names such as Carter, Chase, Collins, Cook, and Curtis, etc.  
 
Setting the filter to "C" when records are being viewed by record number would cause the grid to be blank because record numbers do not begin with letters, they begin with a number. Setting the filter to "5" when items are being viewed by record number would restrict the display to records 5, 50, 51, 52..., 500, 501, 502..., etc.).