Non-Unique Sequential ID numbers field
My assigned task is to create a field in a table that shows a unique number for each record created but isn't the Record # ID field (as this field number is unique to the table) and we need a number ...
Forum Discussion
On your Initiatives Table, you will have to set [Initiative Name] to Unique
Here is a picture of Mark's solution with one more feature, you should Snapshot the Name as well. Even though you want Unique Names, that does not guarantee you that they do not change. Someone can easily put in SAP Deploymnet and then correct it to SAP Deployment.