title: Relating a child table to multiple parent tables
body: <p>I am trying to figure out the best way to relate these tables together. Suppose I have the following tables:</p>
  
  <ul>
  <li>tblPerson</li>
  <li>tblGroup</li>
  <li>tblResource</li>
  </ul>
  
  <p>Each row in each of these tables can have multiple email addresses associated with them so I would want a separate table and relate it back. </p>
  
  <p>Are there methods to have a single table (tblEmail) relate back to each of the tables. I thought of using a uniqueidentifier field in each of the parent tables and using that as a key in the email table. It would be guaranteed unique. I just wouldn't be able to create a FK in the email table to preserve integrity. That is manageable though.</p>
  
  <p>Is there a fancy way to do this? I am creating these tables in SQL 2008 R2.</p>
  
  <p>Thank you
  Karl</p>