View Single Post
  #1  
Old September 4th, 2009, 10:29 PM posted to microsoft.public.access.tablesdbdesign
NFL
external usenet poster
 
Posts: 74
Default 30 Questions & 300 Students

I'm sure I asked this same question in the past. Sorry for bringing it up
again.... I did make some progress (thank you for your input!)

I was able to create a many-to-many relationship between classes and
questionnaire. I was also able to create a one-to-many relationship between
student and classes (one student.. many classes). I have a student form
alson with a subform list of classes where you can schedule each student. I
also included another subform (tab) called assessment where there are a list
of questions along with courses that are required for training. There are no
relationships between questions & student though. I'm not sure how to create
a relationship between students and questions. What I like to do, if
possible create a relationship and then create a process where Access can
automatically create a new record of courses needed based on how the
questions are answered (yes/no).

Thank you again for your help