Searching for a Database Record

The Find option is available on the Membership Database window; Match Administration window; and, Competitor Administration window. Find initiates a matching string search through the records. You can determine what field is searched for the matching string, if the string can appear as part of the field, and the order the records are searched. The search is not case sensitive.

If you are searching the Membership Database, you can search the Family Name, Given Name, Region, IPSC Alias, or Date of Birth fields.

If you are searching the Match List, you can search the Date, Name, or Region fields.

If you are searching the Competitor List, you can search the Number, Family Name, Given Name, IPSC Alias, Power, Division, or Category fields.

To search for a string:

1. Open the Member Administration, Match Administration, or Competitor Administration window.

2. Click Find. The Find window opens.

3. Enter the alphanumeric string you want to find in the Find What field.

4. Click the Look In drop-down combo-box, and select the field you want to find the string in.

5. Click the Match drop-down combo-box, and select the option representing where the string must appear in the field:

•	Any part of field: the string can appear as part of the field, and in any position. For example, in a search for "smith" a match is found in "westsmith", and "smith" and "smithleen"

•	Whole field: the string must match the entire field. For example, in a search for smith, a match is only found in "smith"

•	Start of field: the string must begin in the first character of the field. For example, in a search for "smith" a match is only found in "smithleen"

6. Click the Search drop-down combo-box, and select the option representing the search direction.

•	First: the search begins at the first record, and moves down.

•	Up: the search begins at the currently selected record and moves up.

•	Down: the search begins at the currently selected record and moves down.

7. Click Find. The list tab opens, and the first matching record is highlighted.

8. If this is not the record you want, click Find again.