Multiple subgroup entries for one person

[Miked]

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?

 

[John Vinson]

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]