Hi BCSKZN

One way you could do is to have a 'holding' field somewhere, depending on how it needs to increment you could add a System Parameter value, or lets say it is unique to the customer you could hold it on the Company record (just not shown on screen. 

I would then advise creating a Stored Procedure as you can then do bits with it - calling on it with the Execute SQL Statement - you can fetch the value from the field (if null return '1') and update your record, then go back to the holding field and increase it by 1 for the next time

Here is an example, I have a 'Training Course' which has delegates on it, but at a certain time I want to give them a Certification No. So mine is unique per Training Course (as courses themselves have unique number)

If the number hasn't been provided before - to make sure there are no gaps in the numbers, or changing the existing one by mistake. It grabs the CourseCode from the Training Course + the 'DelegateNo' which is the sequence field.

Updates the course delegate and then turns to the training course to update it for next time

Here is an example, I have a 'Training Course' which has delegates on it, but at a certain time I want to give them a Certification No. So mine is unique per Training Course (as courses themselves have unique number)

If the number hasn't been provided before - to make sure there are no gaps in the numbers, or changing the existing one by mistake. It grabs the CourseCode from the Training Course + the 'DelegateNo' which is the sequence field.

Updates the course delegate and then turns to the training course to update it for next time