I have a portal that is from a table titled PAF
Each record has 15 fields in it. In most cases only one or two fields will need to be changed but we want to keep the staff's employment history so what I would like to do is duplicate the last portal record and then just change the one or two fields where change has occurred.
The example below shows all 15 fields stayed the same with the exception of the salary. (it would be really cool if the change could be a different color or highlight somehow)