3 Replies Latest reply on Oct 26, 2015 3:30 AM by siplus

    How would you produce a unique number


      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.