I have a customer object called 'Engineering Projects' which is a parent to another customer object called 'Project Activities'. The 'Project Activities' objects has a Start Date & 'Activity Duration' fields which are manually entered. It also has a 'Due Date' field which is auto-populated using formula of 'Start Date + Activity Duration'. There is also a 'Completion Date' field which is auto-populated when the activity status is updated to 'Complete'. If an activity is completed early (ie. prior to the specified due date) is there any way to auto-update the 'Start Date' on the following activity record to reflect the previous activity's completion date?
