Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Creating a form from two tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 09 Nov 2007 21:58 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.