On Fri, 13 Apr 2007 12:30:03 -0700, AccessIM
wrote:

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]