If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
30 Questions & 300 Students
On Fri, 4 Sep 2009 14:29:01 -0700, 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). Surely that should be a many ao many? Or does each class accommodate one and only one student? The classic "school" database has three tables, which could be named Students (StudentID, LastName, FirstName, other biographical data); Classes (ClassNo, ClassName, other class data); and Enrollment (StudentID, ClassNo, information about THIS student in THIS class). 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). You'll need an Append query and some VBA code to do this. Again, you surely need another table - each Student will get many Questions, and each Question will be asked of many Students. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
30 Questions & 300 Students
Thank you ... it sure helped a lot
"Piet Linden" wrote: 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. |
#5
|
|||
|
|||
30 Questions & 300 Students
I got the tables (relationships) to work. I'm not sure (understand)
what/how the append query works. However, I did create a query and a form based on that query. Now I would like to add that information to a table without removing any data already on that table. Is that possible? Thank you! "John W. Vinson" wrote: On Fri, 4 Sep 2009 14:29:01 -0700, 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). Surely that should be a many ao many? Or does each class accommodate one and only one student? The classic "school" database has three tables, which could be named Students (StudentID, LastName, FirstName, other biographical data); Classes (ClassNo, ClassName, other class data); and Enrollment (StudentID, ClassNo, information about THIS student in THIS class). 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). You'll need an Append query and some VBA code to do this. Again, you surely need another table - each Student will get many Questions, and each Question will be asked of many Students. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
30 Questions & 300 Students
On Thu, 10 Sep 2009 09:32:01 -0700, NFL wrote:
I got the tables (relationships) to work. I'm not sure (understand) what/how the append query works. However, I did create a query and a form based on that query. Now I would like to add that information to a table without removing any data already on that table. Is that possible? An Append query gets records from one place - a "source", which can be a query or can be a list of values - and creates a new record in a table, the target. Since I have no idea how your table is currently structured, nor any idea what you want added and where you want it added to, I'm a bit flummoxed about how to reply. More details please? -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|