Table Setup For Survey DB Using Multiple Sets of Questions (1 Viewer)

Good morning,

I am having problems figuring out how to set up my table/query structure for a series of surveys that are based on specific user groups. In a nutshell how do I set up the relationships for the Questions, Employees, and Answers if I have the following tables (simplified):

tblQuestions
--------------------
QuestionID (P)
UserGroupID
Question

tblEmployees
--------------------
EmployeeID (P)
Name
UserGroupID

tblAnswers
--------------------
AnswerID (P)
QuestionID
EmployeeID
Answer

The functionality requirements are:

1. Create a set of questions for two or more user groups (each set contain different questions).
2. Assign Employees to a specific user group.
3. Employees are able to enter the DB to answer the questions within their user group.

What should happen is the employee accesses their set of usergroup questions and enter the corresponding answers. Each time I try to set up the relationships however, the answer field ends up being uneditable.

Any help you can give would save what little hair I have left.

Thanks!

Bob

Bob,

Welcome to the forum!

This type of DB has been discussed quite extensively around here. You might get some good ideas from doing a search on the topic.

Thanks Ken, that is what I have been doing for the last 30 minutes or so.

I now understand I need to use an Append Query. I am now trying to figure out the best way to incorporate it into my DB.

Thank You!