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 that is unique to each task but associated with a single initiative. So the sequential number will be associated with a unique initiative name and if the user selects a different initiative name then the sequential number will start at 1.