Hi would appreciate any ideas on how to solve my below issue.
In an insurance database when the initial policy (Record) is created there is a unique number given this is called the policy number. This number would not change for the life of the policy which may involve many annual renewals over many years.
I assume that it would be a calculation that would be contained in a script which would issues the next number when a "New policy" is issued.
The number would be captured for each renewal.