How many Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
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.
 
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.
 
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?
 
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.
 
Hi Duane,

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

Thanks,
Linda
 
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.
 
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.
 
When viewing the table design, select View->Indexes and you will see the
unique index defined in the table.
 
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.
 
Back
Top