title: The DELETE statement conflict REFERENCE constraint
body: <p>I get the error </p>
  
  <blockquote>
    <p>The DELETE statement conflicted with the REFERENCE constraint
    FK_DocYDocument1 - table DocYDocument, column SubDocID - Statement:
    DELETE FROM DOCUMENT WHERE (ID=?) Parameter: 'D7FAA3CF...'</p>
  </blockquote>
  
  <p>Table DocYDocument has columns </p>
  
  <pre><code>PK ID, FK DocID and FK SubDocID. 
  And the keys PK_DocYDocument, FK_DocYDocument and FK_DocYDocument1.
  </code></pre>
  
  <p>FK_DocYDocument1 foreign key column is SubDocID and FK_DocYDocument foreign key column is DocID.</p>
  
  <p>Is there a problem with database design or do I've to look for the error in the program?</p>