View Single Post
  #3  
Old September 5th, 2009, 02:56 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default 30 Questions & 300 Students

On Sep 4, 4:29*pm, NFL wrote:
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


I would start by downloading At Your Survey, available at Roger
Carlson's website http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

Then you can extend it from there.