Displaying Lookup windows

To make searching easier in the Lookup window, use the data control to move through records or use Find to query the data. After you locate the data, you can insert it in the appropriate text box or cell.

To display a Lookup window, do any of the following:

• Click the drop-down arrow in the data control.
• Click the drop-down arrow next to the text box.
• Right-click in a cell of a column, and then select a window from the menu.
• Select a cell and press the F5, F6, F8, or SHIFT+? keys.
• Select a cell, enter a word or partial word, and then press F5 or Shift+?. The Lookup window displays the first occurrence found in the database.
• Select a cell, type a wildcard, then enter a word or partial word and press F4. The Lookup window displays every occurrence found in the database.
• Double-click the cell or column title.
• Select the cell or column and click the drop-down arrow in the cell.

Tip: If you delete a column accidentally, or have hidden a column you want to see again, you can right-click on any column header and click [Show All] to display all columns.