Struggles w/ Survey Database

[Guest]

I'm trying to put together a database for a Customer Service survey.
I have 6 questions on the survey. Each question could be answered as
Strongly agree, Agree, Neutral, Disagree or Strongly disagree.

So far I have multiple tables set up -
tblQuestions - QuestionID (auto), Question
tblAnswers - AnswerID (auto), ResponseID, QuestionID, Answer
tblResponses - ResponseID (auto), QuestionID, AnswerID, and a few others

If I use a query that pulls these tables together in a query - the query
result is blank. I think it's because there is no data yet to display. I'm
fronting a user input form with this query. So, how do I get the form to
open so a user can input data?

I'm stuck. I intend to populate the tables by the user Input form. Does
anyone have an idea? I'm frazzled at this point...

 

[Fred Boer]

Dear Sharon:

You would do well to look at "At Your Survey", found here:

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

Cheers!

 

[Guest]

tblAnswers and tblResponses seem to be redundant to me. Why are you storing
identical information in two different tables?

You don't want to base your form on a query. It should be based solely on
either tblResponses or tblAnswers ( and the other table probably shouldn't
exist ). You would display tblQuestions as a sub form on your form, but
end-user input shouldn't change any data in it.

You can automatically sync the question ID your question sub form and your
main entry easily enough.