Define a self join that matches records on your current field.
Yourtable::FilingName = YourTable 2::FilingName
Define a Seq as a number field with this auto-enter calculation:
Max ( YourTable 2::Seq ) + 1
Clear both the "do not evaluate if all referenced fields are empty" and the "do not replace existing value..." check boxes
Set up a new text field that combines a version sequence with the name produced by your calculation:
FilingName & "v" & Right ( "0" & Seq ; 2 )
Select a unique values validation field option for this new text field. (if two different users were to try to create a new record with this same name at the same time, duplicates could still be created.)
Thanks Phil as always. One quick question, say there are a string of ones that duplicate a value, would there be a way to have the self modifying name add the sequence number to the highest value. Say there was FilingNamev02 (Using the above calc) and a FilingNamev03, the next one would then be FilingNamev04.
I'm not sure that I understand the question.
You appear to be asking for each matching value to be numbered sequentially and that's exactly what will happen with the Max function based auto-enter calculation.