I have an access database which we are using for planning purposes. We are back dating the project from the delivery date using estimated hours for the work. This then calculates the complete dates for each of the tasks.
Once the planning dates are sent, we would like to allow the user to be able to go to the field and write over the date in the field and change it to a new planning date.
Is this possible?
1. Planned Delivery Date = Date entered by user
2. Inspection Comp Date = Planned Delivery date - Packaging Hours Est
3. Assembly Comp Date = Inspection Comp Date - Inspection Hours Est
What if I then want to allow the user to go into the app and change the inspection complete date without changing the other dates that come before the inspection date?