title: How to create a form to edit a one to many relationship?
body: <p>Using MS Access 2007, I am creating a student management database. I have tables for:</p>
  
  <ul>
  <li>Students </li>
  <li>Courses</li>
  <li>CourseSection</li>
  </ul>
  
  <p>What I needed is a way to assign students to a course section. So I created a table that links students and sessions:</p>
  
  <ul>
  <li>StudentsInSection (contains foreign key to students and foreign key to course section)</li>
  </ul>
  
  <p>I would like to create a form that allows me to edit a section and add students from the list of students. I've done lots of relational database work, just never with access. It seems like such a simple thing. Anybody know a good way to do this?</p>