Answer 4
Assuming you have a table of estimated time for starting a task after the start of the project, like this:
Estimated ForTask
24 2 ' ie, add 24 days to the start of the project to get the start ot task 2
... ...
111 5
115 6
125 7 ' add 125 days to the start of the project to get the start of task 7
145 8
Assuming all the task are already in the 'running' table,
Assuming that on MODIFYING, say, task 5, you then wish to AUTOMATICALLY update starting (ending would be similar) tasks 6, 7 and 8
It is then a matter to change date associated to task 6 with 115-111 days after newStartingDate for task 5
and to associate task 7 with 125-111 + newStartingDate for task 5, ... etc.
So, we need two parameter, the task number which is modified and the newStartingDate for this task.
UPDATE runningTable ' not the one with estimated time, but the one with actual data
SET startingDate = [newStartingDate]
+ DLookup("Estimated", "estimatedTimes", "task=" & task)
- DLookup("Estimated", "estimatedTimes", "task=" & task -1)
WHERE task > [updatedTask]