The Show Values window displays the values contained in the selected text or numeric column. The window displays up to 100 values for each column.
For example, if you select a column called State, the Show Values window displays up to the first 100 states in the database. You can use the values displayed in the Show Values window in expressions, conditions, and Having clauses if desired.
To insert a value into an expression, Having clause, or Where Clause, double-click the value.
You can access the Show Values window from the Expression Builder (see Accessing the Expression Builder , Having Clause Builder, Where Clause Builder, and Key page of the Lookup Tables wizard.