I need to write a scheduling program, where a task can be dependent on another task. Each record will have a start date, number of days, and end date(end date is a calculation of start date + number of days.), dependent on(True or false), and Dependent on Record Number(The ID of the task that the record is dependent on).
Now if phase two is dependent on phase one, The phase two date can not be less than phase one end date.
Now my issue is if the user where to go back and edit the phase one date, say extend it by 15 days, I would need for the phase two to automatically move forward so that its start date does not occure prior to the phase one end date. (This would work the same way Microsoft Project works).