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
|
|||
|
|||
Multiple subgroup entries for one person
I have a table with peoples names, and multiple questions to be filled out by
a supervisor. If this is to be done 4 times a year, can I have sub groups for each person so that I don't need to have all 4 sets of questions in one row? I want it Like this: joe smith Question_1 Question_2 Question_3 Question_1 Question_2 Question_3 Rather than: joe smith Question_1 Question_2 Question_3 Question_1 Question_2 Question_3 Is that possible in a table? And if so, How? |
#2
|
|||
|
|||
On Wed, 6 Apr 2005 07:31:11 -0700, "Miked"
wrote: I have a table with peoples names, and multiple questions to be filled out by a supervisor. If this is to be done 4 times a year, can I have sub groups for each person so that I don't need to have all 4 sets of questions in one row? I want it Like this: joe smith Question_1 Question_2 Question_3 Question_1 Question_2 Question_3 Rather than: joe smith Question_1 Question_2 Question_3 Question_1 Question_2 Question_3 Is that possible in a table? And if so, How? If you have a one (person) to many (questions) relationship, then you should have TWO TABLES in a one to many relationship. If the same questions are asked over and over, then you need *three* tables: People PersonID LastName FirstName other bio data Questions QuestionNo primary key Question text Answers PersonID who QuestionNo which question QuestionDate when Answer what You'ld have a Form based on the People table with a subform based on the Answers table. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple entries | TJ | General Discussion | 2 | February 18th, 2005 04:29 PM |
Help..total multiple entries in a single cell... | bjack56 | Worksheet Functions | 5 | December 23rd, 2003 12:51 AM |