Error: The DELETE statement conflicted with the Reference Constraint "FK_DESIGNATION_DESIGNATIONLEVEL2ID" - when deleting a designation

I am trying to delete a fund in our fundraising hierarchy. There are no gifts recorded in the fund, so I should be able to delete it but receive the following error message: Data could not be saved.  
The DELETE statement conflicted with the REFERENCE constraint "FK_DESIGNATION_DESIGNATIONLEVEL2ID". The conflict occurred in database "XXX", table "dbo.DESIGNATION", column 'DESIGNATIONLEVEL2ID'.

 
Our Product Development team has reviewed this issue, its impact in the software, and the availability of an alternative solution. After careful consideration, we have determiend that this issue will not be addressed curretnlyin the Altru software. Please follow the steps below to mark this designation as inactive.
  1. Click Fundraising > Fundraising Hierarchies
  2. Click the arrow next to a designation 
  3. Click Mark Inactive

Steps to Duplicate

  1. Click Fundraising > Fundraising Hierarchies
  2. Click the arrow next to a designation 
  3. Click Delete > Receive error message

Environment

 Altru Arts & Cultural

Was this article helpful?