Performance Review

[Ebes1099]

I'm attempting to set up a Database that will be used for staff performance reviews. I've looked over the "At Your Survey" database and tried to model it similar to that. I have tables called "Employees", "Questions", "Responses", and "ResponseList".

The Employees table has a list of all employees along with some info, each is assinged a uniqueID (AutoNumebered, PK). The Questions table has all the questions, also each assigned a uniqueID, (AutoNumbered, PK). The Responses table I was going to try and use to store the responses for each employee. I have it set up like a Junction table where it has EmployeeID (Foreign Key), and QuestionID (Foreign Key) and Response. The ResponseList is a table with a QuestionID (Foreign Key), and Response text field. It lists every possible response for a given question (I think this is exactly how its set up in At Your Survey).

The problem I have is trying to set up the form the user will open to evaluate employees. Obviously I will need it to list the questions, then it can have a drop down for the responses. But how do I get these responses entered into the "Responses" table and stored there? What is my record source on the form I'll be creating for the user? It seems like it will need to be some combination of the Questions table and ResponseList table. But then how do the answers get to the Responses table?

Thanks for the help.

 

[dhookom]

Check out the form in At Your Survey [frmSurveyResponses]. is bound to tblSrvRspns and has a continuous subform bound to tblResponses. The [Enter Results] button runs an append query to populate the subform.

Duane
Hook'D on Access
MS Access MVP

 

[Ebes1099]

I can't quite figure out how you have the continuous subform working. I might have my table structure set up differently than you.

Here's the setup of my main tables

Employee
--------
EmployeeID (AutoNumber, PK)
Name
Position
etc...

Questions
---------
QuestionID (AutoNumber, PK)
QstnText
QstnLvl1
QstnLvl2


Responses
---------
ResponseID (AutoNumber,PK)
EmployeeID (Links to Employee table)
QuestionID (Links to Question table)
Response

ResponseList (this table has every possible response for each question)
------------
QuestionID (Links to question table)
Response (possible response)


I'm thinking I'll select an employee from a drop down box on the main form, and the subform will have all the questions to answer for that employee. Each answer will be in a drop down box for the user to select. So what would I use for the record source of the main form and the subform?

 

[dhookom]

Employees would be the record source of the main form and Responses would be the record source of the subform. You wouldn't necessarily need a drop down on the main form since navigating to a different employee would have a different set of records from the Responses table.

I'm not sure how you would handle multiple evaluations over time for the same employee.

Duane
Hook'D on Access
MS Access MVP