Filter an ODBC table

In many cases, you will only work on a limited number of records in a table. To filter the contents of a table, use the built-in Filter by Form function.

  1. Open the table you want to filter.

  2. Click the Filter by Form button, images\ico_filt.gif.

  3. Type the criterion for the filter, for example, q* in the ENAME field will extract all object names starting with q.

  4. Click the Apply Filter button, images\ico_app.gif.

Result: The records matching the filter appear.