title: Creating foreign key constraints for multiple tables
body: <p>I have a table called <code>ProjectList</code>. I have two other tables called <code>Estimates</code> and <code>Orders</code>.</p>
  
  <p>The Primary keys for <code>Estimates</code> and <code>Orders</code> <del>and</del> <em>are</em> foreign keys in <code>ProjectList</code>. A <code>ProjectList</code> record is created first, then <code>Estimate</code> records are created and then and an <code>Order</code> record.</p>
  
  <p>How would I create foreign key constraints in <code>ProjectList</code> for <code>Estimates</code> and <code>Orders</code> without violating the <del>Order</del> foreign key constraints?</p>
  
  <p>The only thing I can think of is create an empty Orders record when an Estimate is created.  Not sure if that is an elegant solution.</p>