Review Information Database

[Guest]

I need to create a database that tracks the progress of supervisors on their
performance review requirements.

Each supervisor has their own set of objectives that they need to complete
in the fiscal year. I am trying to create a database that tracks each
supervisors objectives and whether or not they have completed the objective.

I have tried several different design but have not been satisfied with any
of them.

Does anyone have any suggestions on the best way to do this? I have tried
all objectives in one table with a name field to identify the supervisor they
belong to, also tried each supervisor having their own table but am concerned
with this being too much maintenance if new supervisors come or a current
supervisor leaves.

Any thoughts are greatly appreciated. I am really stumped on this one.

 

[Guest]

Have a table for all Supervisors and a table listing all Objectives.
Relate both tables in a one-to-many relationship to a third table SupObj.

SupObj --
SupObjID - primary key - autonumber - integer
SupID - number - long integer - foreign key related to Supervisors primary
key.
ObjID - number - long integer - foreign key related to Objectives primary key.
DueDate - DateTime
CompDate - DateTime
VerifiedBy - text
Remarks - memo

You can use the dates to see if completion goal has been met. If met early.
How much time left to complete. Rollup for percent complete, late, or early.

 

[John W. Vinson]

Does anyone have any suggestions on the best way to do this? I have tried
all objectives in one table with a name field to identify the supervisor they
belong to, also tried each supervisor having their own table but am concerned
with this being too much maintenance if new supervisors come or a current
supervisor leaves.

Any thoughts are greatly appreciated. I am really stumped on this one.

Well, the one table per supervisor idea is definitely not a good idea, just as
you concluded.

You need THREE tables:

Supervisors
SupervisorID
LastName
FirstName
<etc>

This table may better be simply a query selecting all Supervisors from your
Employees table, if you have one.

Objectives
ObjectiveID
Description
<other info about the objective>

ObjectiveAssignments
SupervisorID <link to Supervisors, whose objective is this>
ObjectiveID <link to Objectives, what is this person's objective>
<fields about THIS objective for THIS supervisor, e.g. due date, completion,
comments>

John W. Vinson [MVP]