title: Creating one-to-many relationship in Access shows only " Indeterminate" Relationship Type option
body: <p>So basically I am trying to design my simple Employee/Mission Tracking Database using Access.</p>
  
  <p>I wanted to create a relationship between <code>Employee</code> table and <code>Mission</code> table ( many-to-many). Therefore, I needed to create a bridge-or conjunction- entity, I named it <code>Mission_Assignment</code>. Obviously, PKs of the two related tables ( <strong>Mission_ID</strong> and <strong>Employee_ID</strong>) should be included in this bridge entity as foreign keys. </p>
  
  <p>When I tried to join <code>Mission_Assignment</code> with <code>Mission</code> by dragging the PK <strong>Mission_ID</strong> to the other table, Access didn't show me the option of making this relation as one-to-many, even if I have checked the Enforce refrential integrity box. The only option I got is "Indeterminate" relationship type! </p>
  
  <p>I want to know why this happened? Why can't I have this one-to-many relationship? 
  I tried to change the data type of the PK of the related table using Lookup Wizard, in order to be recognized as a foreign key in the conjunction table, but it didn't work.</p>
  
  <p>Any help would be appreciated. </p>