title: Creating relationships in Microsoft Access
body: <p>I'm creating a database to track my students' participation in classes.  This is what I've set up so far.  I'm working in Access 2007.</p>
  
  <p>Participant Master table - name, contact info, enrolled class, enrolled semester.  Enrolled class (Class A, Class B, Class C) and enrolled semester (Semester 1, Semester 2) are defined in tables.  Primary key is an autoincrement number but students all get a school ID number (ParticipantID).  </p>
  
  <p>Query1 pulls name &amp; address for students enrolled in class A, semester 2 
  (<code>SELECT name, address FROM ParticipantMaster WHERE EnrClass = "Class A" and EnrSem = "Semester 2"</code>).  The query works.</p>
  
  <p>DailySessionLog is a table to represent each daily class.  Includes fields for date, instructor name (check from list), discusssion topic (check from list).</p>
  
  <p>Now I want to link DailySessionLog to Query1 -- letting me check off every day whether a student was there for None, Partial, Half, or Full session that day.  I'm having trouble linking these and creating a subform.  Any help?</p>
  
  <p>I tried having a ParticipantID field in DailySessionLog which I linked to ParticipantID in Query1.  It doesn't recognize if it's a one:one or :many relationship.  If I go ahead and create a subform using the Access wizard it treats the Participant data as the "higher" form and the DailySessionLog data as the "sub" form.  I want it to be the other way around.  </p>
  
  <p>Thanks for helping!</p>