Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

Read all instructions including the Notes before performing this function.


Globally delete the constituency code:

    Note: If the Constituent Code field is marked as required and the constituent only has one constituent code listed, the constituent code is not deleted. If this is the case, consider temporarily unmarking the field as required, deleting the constituent, re-adding the constituent code, and then remarking the field as required.
    1. Create a static, constituent query and filter on Constituency > Constituency Code is equal to [the duplicate constituency code]. Save close this query.
    2. Go to Admin > Globally Change Records.
    3. Double-click Constituent from the Constituent category.
    4. Click Include and select the query created in Step 1.
    5. In the Show field, select Constituency Codes.
    6. Double-click Constituency Code.
    7. Select Delete in the Operation field and the duplicate constituency code in the Delete field
    8. Click OK.
    9. Click Change Now to delete all instances of the constituency code on the constituent record.


    Globally add the constituency code:

    1. Go to Admin > Globally Change Records.
    2. Double-click Constituent from the Constituent category.
    3. Click Include and select the query created in step 1 in the section Globally delete the constituency code.
    4. In the Show field, select Constituency Codes.
    5. Double-click Constituency Code.
    6. Select Add in the Operation field and the duplicate constituency code in the Add field.
    7. Click OK.
    8. Click Change Now to add the constituency code on the constituent record.


    Note: The constituency code is added as the last constituency code on the constituent record. Therefore, if it was the primary constituency code before being deleted, it is no longer the primary constituency code after following the above instructions. To avoid this:
     
    1. Create a second static, constituent query (Query B) and filter on Primary Constituency Information, Constituency Code equals [the duplicate constituency code]
    2. Merge this query with the query created in step 1 above (under Globally delete the constituency code). Use that query as the primary query and Query B as the secondary query with SUB as the operator.
    3. Use the resulting query (Query C) in the steps above. This prevents all constituents with it as a primary constituency having it globally removed/added.
    4. Manually delete the duplicate constituency code from the constituents in Query B:
    a. Open Query B in Query and select the Results tab.
    b. Double-click the first constituent in the query to open the constituent record.
    c. Select the Bio 2 tab and delete the duplicate constituency code
    d. Repeat steps a, b, and c for each constituent in the query.