I am setting up a database to monitor the progress of projects. For each project I have an "initial estimated completion date" and a "current estimated completion date". At the start of a project I want to be able to enter the "initial estimated completion date" and also, without having to re-enter the data, assign this date to the "current estimated completion date" as well.
Subsequently the "current estimated completion date" would be updated as the project progressed and we would be able to compare this date to the date we originally estimated.
Hope you can follow that, what is the best way to acheive this?
NB There are actually lots of different stages to each project with initial estimated dates and current estimated dates so entering the data twice would be quite time consuming.
thanks