I am trying to do something I thought would be reasonably simple but turns out not. It may be a limitation, in which case please could someone tell me, otherwise any assistance would be appreciated.
I have two sharepoint lists, identical in structure, one list has current jobs the second list is a "completed" jobs list. When a status field on the current job list is changed to "Completed", I simply want to create a new job in the same list but only retaining a couple of the original item details (this is working fine) and copy / move the original job to the "completed" jobs list retaining all the original data. It mostly works except for a multline text field (versioning is turned on) which we use for notes / comments - the entries in the original item are not being copied across to the copy of the record in the "Completed" list and hence we are not able to keep an exact copy of the record to look back at in the future should we need to.