I have a table called Opportunities and on that table we have a field with the current status of the project. I'm trying to make a field that will create a unique Job Number (with a text prefix) after the status has been changed to "Won". I originally made it pull the [Record ID#] so we would just be using that (ex. IPV-234, IPV-256, IPV-261) but we would like the Job Numbers to be consecutive (basically ignoring the opportunities we did not win but still having a record of them if there is a change in the future). Is there anyway to create a field that would do this and go back through the old Opportunities and give them sequential Job Numbers (ex. IPV-0001, IPV-0002, etc.)?