The ability to filter the records in tables such as the Customer table is a powerful feature here.
Click this button or use View | Filter... to open the Filter dialog and limit your selection of Customers.
The three fields to the right side of the speedbar show the current count of Selected, Filtered and All records.
| 1. | Selected shows how many Customers are currently in the Customer List (6). |
| 2. | Filtered shows how many Customers are active based on the current filter (16). These are the only Customers displayed and the only ones affected by Select All or UnSelect All. If there is no filter active, or if that filter did not exclude any Customers, then the Filtered and All values are the same. |
| 3. | All shows how many Customers are in the Customer table (20). |
When viewing a table displayed in a grid format, some field headings may be colored either "green" or "blue". This means you can view the table sorted by additional fields. The table is initially sorted on the field whose heading is "green". If a field heading is "blue", then you can view the table sorted by that field by clicking that field heading.
Options menu
Click this button or use Options | Toggle Current or double-click a field in the record to "toggle" the selected status of the current Customer (e.g. either add it to the Customer List or delete it from the Customer List). The "Selected" field for the current Customer will be set to "True" if it is currently blank; or will be set to blank if it is currently "True".
Click this button or use Options | Select All to add All the active Customers to the Customer List. The "Selected" field for all active Customers will be set to "True". When a filter is active then active Customers means only those Customers that satisfied the filter. Don’t worry about adding the same Customers more than once because any existing ones already in the Customer List will be ignored.
Click this button or use Options | UnSelect All to remove All the active Customers from the Customer List. The "Selected" field for all active Customers will be set to blank. When a filter is active then active Customers means only those Customers that satisfied the filter. Don’t worry about removing Customers that aren’t in the Customer List because they will just be ignored.
