title: How to add data from MS Access Data Entry form while maintaining the table relationship integrity
body: <p>I have a Student and Course Tables. </p>
  
  <pre><code>Student
    ID - Primary Key - AutoNumber
    CID - Number
    FirstName - Text
    LastName - Text
  
  Course
    ID - Number
    CourseTitle - Text
  </code></pre>
  
  <p>I have a data entry sub form where I can enter a <code>CourseTitle</code>, <code>FirstName</code> and <code>LastName</code> and when I click Save Record, the data is saved to Student and Course tables. However, the second time around when I enter same course title, it adds another row with same name in course table with different ID. If I'm entering a course name that already exists then it <strong>should not</strong> add a new course title. </p>
  
  <p>Example</p>
  
  <p>Assume that before saving the record the state of data is:</p>
  
  <pre><code>Course
  -------
  
  ID     | CourseTitle
  -------|-------------
  1      | Maths
  
  Student
  -------
  
  ID      | CID    | FirstName    | LastName
  --------|--------|--------------|----------
  1       | 1      | Mike         | Someone
  </code></pre>
  
  <p>Now, when I save the data from the Data Entry Form:</p>
  
  <pre><code>Course Name = Maths
  First Name = Junior
  Last Name = Someone Else
  </code></pre>
  
  <p>The state of Data becomes</p>
  
  <pre><code>Course
  -------
  
  ID     | CourseTitle
  -------|-------------
  1      | Maths
  2      | Maths
  
  Student
  -------
  
  ID      | CID    | FirstName    | LastName
  --------|--------|--------------|----------
  1       | 1      | Mike         | Someone
  2       | 2      | Mike         | Someone
  </code></pre>
  
  <p><strong>Question</strong>
  However, I want the data to look like:</p>
  
  <p>How can I make this happen??</p>
  
  <pre><code>Course
  -------
  
  ID     | CourseTitle
  -------|-------------
  1      | Maths
  
  Student
  -------
  
  ID      | CID    | FirstName    | LastName
  --------|--------|--------------|----------
  1       | 1      | Mike         | Someone
  2       | 1      | Mike         | Someone
  </code></pre>