Search for and select existing column values using the List Values window

Use the List Values window to display values that are currently associated with a specified column, and choose one or more of these values to add to a search condition. When the List Values window opens, a search is performed on the selected column and the results are displayed in the Values field.

You must select a column before values for that column can be retrieved. If the Values field is blank, make sure that you selected a column.

To modify a search in the Find Column Values window:

  1. Select a value from the Search limit list to control the number of values that are returned for the search. The default limit is 25 values.
  2. Click Search. The results of the search are displayed in the Available values list, up to a maximum number of rows as specified by the Search limit value.

To add a value from the List Values window to a search condition:

  1. Select one or more values from the Values list. In most cases, you can select only one value.
  2. Click OK. The List Values window closes, and the selected values are added to the appropriate field in the Details area.

See also:

Add search conditions to an SQL statement (WHERE or HAVING clause)