To find and correct invalid Company ID values

1. From Customers, click Find.

   The Search dialog appears.

2. From the drop-down list of search types, select Ad Hoc.

   The Select Search Instructions dialog appears.

3. Click New.

   The Search Instructions dialog appears.

4. In the Search Name field, enter a descriptive name such as Find Invalid Company ID.
5. From the Mode options, select Calculation.
6. In the Comparison Value field, enter Name.ID=Name.CO_ID.
7. Click Save.

   The new ad hoc query is listed in the Select Search Instructions dialog.

8. Click OK.

   If any records matching the search criteria are found, they are listed in the Results tab.

9. Correct each record found.