Collect! Credit and Collection Software™

  Page Table of Contents Related 'How To' Tutorials

How To Search For Records

There are several ways to search for records in your database:

The first two methods can be used when a list is displayed. These methods work for any list that you are viewing anywhere in your Collect! system.

List View - Column - Finding A Record Based On A Single Criterion

Whenever you display a list, your cursor will appear on the first field in the list. For example, when displaying the Debtor list, your cursor will appear on the Debtor Name field.

If you start typing the name you are looking for, Collect! will start searching through the list for a record matching the name. If it finds a record containing what you typed, the first matching record will be displayed in the list.

The Debtor Name field is indexed and the search should complete very quickly. If the field is not indexed, Collect! will have to scan through the complete list to find a matching record. In this case, you will see a message at the bottom right of the screen indicating that Collect! is searching. If you press any key while it is searching, Collect! will cancel the search and display a message to the effect that the 'Scan was canceled by the operator'.

To search on another field, press the Tab key until the cursor is flashing on that field. If you search on the Debtor Number, the process is a little different due to the fact that the debtor number is a numeric field. Collect! can't find a match on a numeric field until all numbers have been entered. For example, if your Debtor's Number is 10021, then you will need to type the complete number for Collect! to find the record in the database. This is simply because the field is a number, and Collect! processes numbers differently from text.

Useful Note This type of quick search is available on every list in the system.

Top of page.

List View - Search Criteria - Finding Multiple Records With One Or More Criteria

You may want to search for records based on more than one criterion. When you are displaying a list, press F6 (Find) to open the Edit Search Criteria window.

Click Here to View this Form.

This type of search capability is available in all lists in the system.

Useful Note The default Indexed fields are displayed with a prefix [#] in the Field column. Searches on these fields will go faster than searches using non-indexed fields.

Useful Note You can create your own indexes in the database.

Collect! remembers your search criteria. If you enter something into the Edit Search Criteria window, and Collect! can't find the record, pull down the Edit menu and choose 'Clear Search Criteria' to reset your options.

Top of page.

Quick Search And Find By

You can also use the Quick Search feature from the Main Menu to search for records.

Click Here to View this Form.

For more advanced searching, use the Find By menu.

Click Here to View this Form.

Top of page.

Database Query

You can use SQL queries to search for records. These queries can be executed in a report, or via a database access tool like SQL Server Management Studio.

Warning Note WARNING: Executing SQL queries directly can cause damage to your database, if you are not familiar with SQL. Please contact Technical Support for assistance in building custom reports.

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org