Help Overwriting Data to Reflect Final Condition of Dimension during Load Sequence

[Kosakamaka]

Hello, I am currently developing an application and hit somewhat of a roadblock. The application that I am developing monitors production processing times of different types of assemblies. As assemblies move through the production process cycle times are automatically recorded for the respective serial number. 

The issue arises from the fact that all assemblies start out as the same part number but then depending on demand they may change to an alternate assembly. Furthermore, their serial number will also change if they undergo the part number change. 

What I would like to do is make my dataset consistent and override all data with the final condition of the assembly. This is because both the final serial number and part number are what is tracked. I have provided an illustration of this below. 

 Thank you in advance for any advice on how to tackle this problem. 

[Kosakamaka]

Any help on this topic would be greatly appreciated.