The Search function is used to locate the first record which matches the Search criteria. It is normally used to find a record that couldn't be located using the Go To Record function (which uses only Indexed Fields to find records.
To Search for a Database Record
- Select the appropriate database.
- Select Search from the Find menu to display the Search screen. The Search screen looks like a Database record, but all of the fields are blank and the word "Search" is displayed in the lower right corner of the screen.
- Enter the Search criteria in the appropriate fields. Search Operators may be used with the search criteria. Search criteria may be entered in as many fields as necessary. Select the Lookup List button (or press [Ins] or [F2]) to display a list of the currently available options for a field (if options are available for that field).
- Press [F10] to begin the Search to locate records which match the Search criteria. Records are searched in the current Record Sort order. The first record which matches the Search criteria is displayed. If more than one record matches the Search criteria, press [Shift]+[F2] to Continue the Search until the desired record is located.
For example, to find a Customer whose last name is Smith:
- Select the Customer database, Edit, then select any customer.
- Select Search from the Find menu.
- Enter Smith in the Last Name field.
- Press [F10]
- If there are several Smiths, press [Shift]+[F2] until the right one is located.
To find a Customer whose last name is Smith, and whose first name is Steve:
- Select the Customer database, Edit, then select any customer.
- Select Search from the Find menu.
- Enter Smith in the Last Name field.
- Enter Steve in the First Name field.
- Press [F10].
- If there are several Steve Smiths, press [Shift]+[F2] until the right one is located.
See:
Special Search Operator Characters
Database Manager Contents