How can I datestamp an event?
I have a series of landmarks for a project, each of which is recorded as having been reached by the entry of a date against that event. There are five of these landmarks. I also have another field (in the same table) that gives an update on the status of the project, based on which landmark has been reached. All fields are updated manually and there is no linkage between the date fields and the progress overview field. I'd like one though.
Is there a way to have the filling in of each of the date fields cause the progress overview field to automatically change to show the new project status? Alternatively, is it possible to have the change in the progress overview field to create a datestamp in the appropriate date field for that event landmark?
Which would be the best way to do this, and how could I achieve it, please?