There are 8 possible locations where this table entry can be stored in the Raiser's Edge. Run queries based on the following criteria to identify the record on which the table entry is in use. 

Constituent Queries:
  1. To identify Constituent records using this table entry:
    • Constituent Information>Title 1 (or Suffix 1) equals [specific table entry].
    • Constituent Information>Title 2 (or Suffix 2) equals [specific table entry].
  2. To identify Spouse records using this table entry:
    • Spouse>Spouse Information>Title 1 (or Suffix 1) equals [specific table entry].
    • Spouse>Spouse Information>Title 2 (or Suffix 2) equals [specific table entry].
  3. To identify Individual Relationship records using this table entry:
    • Relationships>Individuals>Title 1 (or Suffix 1) equals [specific table entry].
    • Relationships>Individuals>Title 2 (or Suffix 2) equals [specific table entry].
Participant Queries:
  1. To identify Participant records using this table entry:
    • Participant Information>Title 1 (or Suffix 1) equals [specific table entry].
    • Participant Information>Title 2 (or Suffix 2) equals [specific table entry].

Alternate Solution:

Use the Table Cleanup Wizard to globally replace the unwanted table entry. After the table entry is globally replaced, it can be deleted.