Creating a form from two tables

[Guest]

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

 

[Guest]

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.
--
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.