TblQuestion
QuestionID
Question

TblAnswer
AnswerID
Answer

TblAnswertoQuestion
AnswertoQuestionID
QuestionID
AnswerID

In TblAnswer, be sure AnswerID for "Safe" is 1 and AnswerID for "At-Risk" is
2.

1) Create a query that includes TblAnswertoQuestion and TblQuestion
a) Join QuestionID to QuestionID Type 3 to display all records
from TblQuestion and only those records from TblAnswertoQuestion where the
joined fields are equal
b) Pull into the fields of the query only Question from
TblQuestion and AnswerID from
TblAnswertoQuestion.
2) Create a continuous form based on the query in 1.
a) Use a textbox bound to Question
b) Use an option group bound to AnswerID. Make the first option
have a value of 1 with the label "Safe" and the second option have a value
of 2 with the label "At Risk".
c) Make the options option buttons.

Let us know how this works for you!!!!

Steve



"JS" wrote in message
...
I am trying to create something of a survey database. I have seen the
sample
database "At Your Survey", but I am not sure how to tweak it to what I
need.
I have a form that is for safety observations. Supervisors will observe
procedures and mark them as "safe" or "at-risk". I have a list of things
they
can observe but they don't necessarily have to observe everything on the
list. For example:
1. Stair/Ladder Use
2. Elevated Work
They could observe one of these things and mark it as "safe" or "at-risk".
I
understand the concept of a table for questions and a table for answers
and
then another table for possible answers for each question. I need all of
the
possible observations to show up on the form, even if they are not
selected
as safe or at-risk. I am unsure how to set up the form or the response
table
from the form. I have been reading all the posts and I know that the "At
Your
Survey" is a good example, but I just don't know how to modify it so that
all
my observations show at once on the form. I also would like to have the
"safe" and "at-risk" options as option buttons if possible. Thank you.