title: How to create a data entry form that puts data in two tables
body: <p>I have <code>Student</code> and <code>Course</code> Tables</p>
  
  <pre><code>Student
  --------
  ID - Primary Key - AutoNumber
  Name - Text
  Age - Number
  
  Courses
  -------
  CID - Foreign Key
  CourseTitle - Text
  </code></pre>
  
  <p><code>ID</code> in Student table is linked to <code>CID</code> in Courses</p>
  
  <p><strong>Question</strong></p>
  
  <p>I want to create a simple Data Entry form that collects a Students <code>Name</code>, <code>Age</code> and <code>Course Title</code>. The Name and Age should go in <code>Student</code> table however, the Course Title should go in <code>Course</code> table. </p>
  
  <p>How do I do this? I know how to create a data entry form that puts data in one table but don't know how to put it in two tables while maintaining the relationship. I would really appreciate a screenshot. </p>