MANY TO MANY RELATIONSHIP???

[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.

 

[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.

 

[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?

 

[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?

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.

 

[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