If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Review Information Database
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. |
#2
|
|||
|
|||
Review Information Database
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. |
#3
|
|||
|
|||
Review Information Database
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] |
Thread Tools | |
Display Modes | |
|
|