Serves for performing search (building a request) in a table or a query of GDB or EDB.
The command allows specifying search condition, performing search of records and opening a browser window with the query containing only the records satisfying the search condition.
To perform searching operation it is necessary to specify search condition. Search condition is a condition (limitation) imposed on values of table fields. For some record the condition is considered to be true if the limitation imposed on values of record fields is satisfied for the present record, otherwise the condition is false. When executing the operation the records for which the condition is false are rejected and only the records for which the condition is true are displayed.
When performing the command a dialog box “Search” will be opened which permits specifying search condition.
It should be noted that search operation can performed in the query obtained as a result of search operation. Thanks to this it is possible to continue search narrowing the condition.
The difference of search operation in the base table from search in the query obtained as a result of search operation is the following: the condition specified in query browser window (new condition) will be combined with the condition specified for the table before (old condition). It means that performing search operation in the query not only the new condition, but the old one as well will be taken into account.
To combine these conditions the logical operator will be used which should be necessarily specified for the first simple condition of the new condition. It is supposed that both conditions, the old as well as the new one, are put as if in parentheses.
Thus, the main difference of the command Tools+Search from the page Conditions of the property sheet “Properties of query” is that the command allows specifying the condition added to the existing one, and the full condition of getting a query is represented on the page of the property sheet.
Menu item Tools+Search of the navigation window if a table or a query is selected in the pane.
Toolbar button 
or menu item Tools+Search of table browser window.
Dialog box “Search” for GDB table or query
Dialog box “Search” for EDB query
“Properties of query” for internal query of GDB. Page “Conditions”
“Properties of query” for EDB. Page “Condition”
 |  |
