How many Tables

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
MS Access MVP

"LMB" wrote in message
...
Hi Duane,

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

Thanks,
Linda


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Consider downloading and reviewing the Employee Evaluation sample at
http://www.rogersaccesslibrary.com/O...p#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.

--
Duane Hookom
MS Access MVP

"Sydious" wrote in message
...
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.

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

--
Duane Hookom
MS Access MVP

"Sydious" wrote in message
...
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" wrote:

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.

--
Duane Hookom
MS Access MVP

"Sydious" wrote in message
...
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?
"Sydious" wrote:

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.

"Sydious" wrote:

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.

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.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
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
MS Access MVP

"LMB" wrote in message
...
Hi Duane,

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

Thanks,
Linda


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Consider downloading and reviewing the Employee Evaluation sample at
http://www.rogersaccesslibrary.com/O...p#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.

--
Duane Hookom
MS Access MVP

"Sydious" wrote in message
...
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.