The structure is completely different on our new vendors software. We have 3 different instances on two different Vendor Software Applications now each containing Client Contracts for different Sectors (Companies) within our Organization. The different Sectors may have the same Clients and each...
We are switching to a new Contract Lifecycle Management system. AMD is just a document short naming convention for Amendment. This new system requires the Amendments be numbered under each Contract using the Amendment Number Field.
I am trying to number each row (update the AmendmentNumber) in sequential order based off an ID (ContractID). Example below but also attached a screenshot.
I would like to Order By the Document Name as the Name has a combination of [Contract ID] & [DocumentID] in the beginning of the Name...