I have two issues and not sure they can be solved together:
1. I have a field ID_PK that I will start to use as the actual Tracking ID of items (currently have another field that contains TrackingID), is there a way to auto populate the OldTrackingID field the ID_PK, without overwriting current TrackinID?
2. When TrackingID is update add the FY## to the beginning, which would be based off date of RequestDate field?
Your guidance is much appreciated!