Im looking for assistance.
This database is used for evaluations. so a manager completes a form that
has 25 questions. They do 4 evaluations a month on each employee. I have 3
tables the Evaluation information (Table 1), The Answer Information (Table 2)
and the Question Table (Table 3)
Is there a way to popuplate at form that has all the Evaluation Information,
lists each question from table 3 with the Answer Information for each of
those questions from Table 2.
I haven't begun creating this database yet so if there is a better way to do
it i am open to suggestions.
Table 1
Eval ID
Employee
Eval Date
Evaluator
Table 2
QuestionNumber
Answer
Comment
Table 3
QuestionNumber
Question
boblarson - 09 Nov 2007 23:19 GMT
For more than one table on a form, look into either a query if the tables are
one-to-one or if they are one-to-many use subforms.

Signature
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
> Im looking for assistance.
>
[quoted text clipped - 24 lines]
> QuestionNumber
> Question