MANY TO MANY RELATIONSHIP???

T

Tina S

i need to be able to attribute an employee to a manager by quarter and then
compare that to results in another table. A manager is required to review
each employee one time per quarter, so I need to see if the employee belonged
to that manager for that quarter and then compare that information against
the reviews done.
 
K

Klatuu

Many to Many relationships have to be resolved using a junction table so
that it becomes a many to one on both sides. So what you would need is a
table that would have the year and quarter, a foreign key field to the
manager table and a foreigh key field to the employee table.
 
T

Tina S

I have seen the primary key, but how does this work if I need to attribute a
manage to an employee one quarter and then another manager the next quarter?
 
M

MikeB

I have seen the primary key, but how does this work if I need to attribute a
manage to an employee one quarter and then another manager the next quarter?
Click to expand...

Ooh! I know!

You have the junction table with a key for the quarter and the
employee. Then you have a field for the manager for that quarter for
that employee.

Methinks.
 
F

Fred

The way that I know is

Junction table needs at least these fields:

EmployeeIDNumber
ManagerIDNUmber
Quarter (entries like 2008Q1)

Enter one record in the junction table for each instance of a
Employee/Manager link for a quarter
 
Top