title: update statement conflicted with foreign key constraint. How do I fix?
body: <pre><code>UPDATE TRANS
  SET DateSold = '11/18/2010', SalesPrice = 475.00,
  CustomerID = 1056 
  WHERE TransactionID = 229;
  </code></pre>