title: MS ACCESS: Populate a subform with data from another table
body: <p>I have three tables in my Access Database.</p>
  
  <pre><code>**Table: Participants** 
  ParticipantID   
  FirstName   
  LastName    
  Address
  Phone
  SiteNameLookup  
  YearLookup
  
  **Table: DailyWorkshops**   
  WkshpID 
  WkshpDate   
  AorB    
  SiteStaff   
  Artists 
  Activities
  
  **Table:  ParticipantAttendance**   
  ParticipantID   Participants.ParticipantID
  FirstName   Participants.FirstName
  LastName    Participants.LastName
  WkshpID DailyWorkshops.WkshpID
  Level   *(here I have a lookup to fill in HALF/PARTIAL/FULL, not just yes/no)*
  </code></pre>
  
  <p>I have succesfully created a form, DailyWorkshopsForm, that has a subform of ParticipantAttendance.  This subform is completely blank.</p>
  
  <p>How can I now populate the ParticipantAttendance subform from the Participants form so all I have to do is check off the attendance level for each participant?  I can figure out how to look up just Participant.ParticipantID or just Participant.FirstName or just Participant.LastName --- but looking up one doesn't automatically fill in the others... so I could end up looking up an ID # but not get the name that goes with it.</p>
  
  <hr>
  
  <p><strong>Edit:  Clarification of question &amp; problem.</strong></p>
  
  <p>Thanks... as I look at it more I realize ParticipantAttendance is not what the subform should be... that's just the table where the attendance data should ultimately live.  What I need for the subform is something that looks like this:   </p>
  
  <pre><code>WkshpID ParticipantID   FirstName  Lastname  Level
  
  6   10-45   Bart    Simpson     Full
  
  6   10-47   Ned Flanders    Half
  
  6   10-49   George  Washington  None
  
  6   10-50   Michelle Obama          Full
  
  7   10-45   Bart    Simpson         Full
  
  7   10-47   Ned Flanders    Full
  
  7   10-49   George  Washington  Half
  
  7   10-50   Michelle Obama          None
  
  8   10-45   Bart    Simpson          Full
  
  8   10-47   Ned Flanders    None
  
  8   10-49   George  Washington  Half
  
  8   10-50   Michelle  Obama     Half`
  </code></pre>