Questionnaire

[robcarr]

Dear All,

I am trying to create a Database purely to log and track questionnaires for my company.

I have set up the tables so far and want to make sure I am going down the correct path.

I have 3 tables

tblEmployeeQuestionnaireDone
contains
Employeename
Questionnaire
Question
Answer1
Answer2
Answer3

will hold a record of each employee and which questionnaire they have done and the questions and answers they have given

tblQuestionnaires
contains
Questionnaires
will hold the names of the questionnaires.

tblQuestionsandAnswers
contains
questionnaire
Question
Answer1
Answer2
Answer3
Correct
will hold the questions and answers that are available.

I think this is the correct way to do this. I have set up the relationships as one-to-many and "Include All records from TblemployeeQuestionnaireDone and only those records from tblquestionsandanswers where the joined fields are equal" and the same for tblquestionnaires. Joined fiels are Questionnaire.

could someone let me know/quide me on the best way to go from here.

thanks in advance for any help on this.

Rob.

Hope this is of use, Rob.

 

[lespaul]

Check out the survey questionnaire here:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Thanks to Duane!

HTH

Leslie