Store Modification History and Another Field

[nygiantsfan]

Hi all! Thank you very much for answering my last post. You guys are awesome !




Now I have another problem. I have two tables: one is called task and another is called project. There are many tasks in one project. Task has a field called completion % and a field called last modification date. Project has the two same fields but in this table completion % is the average of the completion % of all its tasks and last modification date is based on the last task modified. I was wondering how I can store the completion % and modification history every time a task completion % is updated so as to have a modification history along with the corresponding completion percent for both projects and tasks. For example May 22nd 50% May 24th 75%. This way I will be able to track the progress of certain tasks and projects. I'm really lost . Any help would be much appreciated. Thanks again guys!

-nygiantsfan

[hansendl]

If you want to maintain a history, you'll need another table with the following fields:

ProjectID
TaskID
Date
CompletionPercentage

You could add an autonumber PK field if you want, or use a composite PK based on ProjectID, TaskID, and Date. This table would essentially replace the two fields (completion % and last modification date) in your Tasks table.

Hope this helps!

[ranman256]

If I read this right....you would have to track the modifications dates and the pcts in ANOTHER table

tMods:
[TaskOrProj] (task, or proj)
[ID]
[modDate]
[Pct]