Can anyone help? I want to be able to auto populate a field within a SharPoint list based on the most up-to-date field within another list.
Projects List - List of projects.
Fields inc. Project ID, Most Recent Comments, Status etc.
Project Comments list - List of Project Comments linked to Project List by Project ID.
Fields inc. Project ID, Subject, Comments, Created Date etc.
Therefore the 'Most Recent Comments' field in the Projects List always has the latest comment.
I know I can either use a workflow or a calculated field but not sure how to start it.
Any help is greatly appreciated. Thanks.