How many Tables

[Guest]

I am building a database for employee performance reviews.

The review on paper has 10 catagories with questions under each catagory
that are rated with a 1- 4 rating system.

My question is do I make a tables as follows?
Employees Table
Name
Hire Date
..and so on.
Catagory 1 Table
Catagory1 question 1
Catagory1 question 2
...and so on
Catagory 2 Table
Cat Question 1
....and so on.
(continue for all 10 catagories)

or........
Do I just make 1 big table for the whole review and an employee table to
match to?

could use any sugestions on this.

 

[Duane Hookom]

Consider downloading and reviewing the Employee Evaluation sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You need
to normalize your tables. Setting up different tables for different
categories and/or multiple fields form multiple questions might not be a
good structure.

 

[Guest]

Just what I am looking to create. Very Nice Work!

I am sort of confused by the evfSort Field in tblEvalFactors tho. What
exactly is this field for. Any why is it displayed on the form?

 

[Duane Hookom]

The evfSort field is just used to sort the factors.

 

[Guest]

Thanks. You lead me in the right direction. I kind of had the idea in my head
but couldn't put it in tables. Thanks for your help!
Again Nice work.

 

[Guest]

One more quick question about your form....
What did you use to get the radio buttons to be the evdRating??
I feel dumb asking this one.

 

[Guest]

Nevermind. Figured out how to work that. (Option Group)

I have a simular form going on now. I kept all your naming conventions and
managed to copy your "Appen Factors" button. I got it to append the factors
on the form but I am having dificulty with 2 things.

1. The button is always seen. Not just on the Second Tab (Factors Tab). It
is always visbile. How do I get it to "stick" on the Factors Tab.

2. When I click the button all 13 factors pop into the form. Problem is when
I click it again it adds anoth 12 factors again. It will continue to do this
everytimne I click. How do I get this to only append once?

 

[Duane Hookom]

1. You need to:
- cut the command button
- select the tab page
- paste the command button onto the tab page
- you may need to re-attach the code
2. Apparently you don't have a unique index on the fields
evdEvalID and evdFactorID
This index would not allow duplicate values.

 

[LMB]

Hi Duane,

I am looking at your evaluations database and I wondered why there are 2
employee tables in the relationships window?

Thanks,
Linda

 

[Guest]

What do you mean by unique index? Is that a proporty? or a relation ship?
I set my tables up like yours. I might have missed a proporty tho.

 

[Duane Hookom]

These are two copies of the same table. tblEvaluations contains a field for
the employee being evaluated and a field for the employee performing the
evaluation.

 

[Duane Hookom]

When viewing the table design, select View->Indexes and you will see the
unique index defined in the table.

 

[LMB]

That makes sense now.. I have an evaluations database also that has the same
thing but I don't think I added the table, it just showed up and it's named
employee1. I kept deleting it but it kept coming back. I guess it's
supposed to be there since employees evaluate other employees.