title: Dynamics AX 2012 Foreign Key Constraints
body: <p>Let's say I have two tables:</p>
  
  <pre><code>Items
    Property1 (relates to PropertyName)
    Property2 (relates to PropertyName)
  Properties
    PropertyName (index, single key alternate)
  </code></pre>
  
  <p>When making a normal relation in Dynamics AX 2012, I get the following Best Practice error: Only foreign key constraints are allowed on this table.</p>
  
  <p>I can create a single key alternate foreign key relation to fix the best practice error.  However, I can only do this for one of the fields.  If I do it for both, I receive a compilation error about duplicate alternate keys.</p>
  
  <p>Is there some way to create normal relations like we used to in AX 2009 without a best practice error?</p>
  
  <p>or.. How can I do two foreign key relations on two fields that relate back to the same column?</p>
  
  <p>Thanks</p>