Contact Search Center Query Editor

1.

At the Default Search/Query Editor drop-down menu in the toolbar, select Query Editor. This adds a window under the default search tools for editing and previewing SQL searches within the Contact Search Center.

When Query Editor is selected from the Default Search/Query Editor drop-down menu, the following window appears:

2.

Select the SQL radio button to view the query in SQL format.

3.

Select the xBase radio button to view the query in xBase format.

4.

To edit the query, click Edit. The view window becomes active for editing.

5.

Edit the query in either SQL or xBase. Click Preview to view the result in the Contact Search Center table.

6.

To close the Query Editor, select Default Search from the Default Search/Query Editor drop-down menu in the toolbar.

Browser Column Selection

By default, the Center displays the Company, Contact, Phone 1, City, State, and Postal Code fields. Change the information in the displayed columns to suit your needs.

In the Contact Search Center, right-click in the column area and select Select Columns. The Browser Column Selection dialog box appears.

■ To add a field to the displayed browser columns, select the field name in the Available columns list and click the right arrow. The field is added to the bottom of the Selected columns list.

■ Fields are listed in the order displayed in the Center. To change the order to the displayed fields, select the field in the Selected columns list and click Up or Down.

■ To remove a field from the Center display, select the field name in the Selected columns list and click the left arrow.

The OK button is available only after you make a change in the dialog box. If you do not make any changes, click Cancel to close the dialog box.