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.
--
KARL DEWEY
Build a little - Test a little


"AccessIM" wrote:

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.