AnsweredAssumed Answered

How would you produce a unique number

Question asked by Raymond on Oct 26, 2015
Latest reply on Oct 26, 2015 by siplus

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.

Outcomes