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?

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]