Describes a method of creating a unique number for each record or detail.
I need to create a unique serial number for each part in my PARTS file. I want to have each number increase by one, and I want to start at 60,000. I have tried a couple of different things with no success. How can I get this to work?
The calculation function INCR( ), introduced in 4ersion 4.4, provides an increment capability to XENTIS.
How it works: It uses three arguments. The first argument is a number field indicating the initial value of the result. The second argument is a number field indicating the increment value. The third argument is a number field or a text field that serves to control the frequency of its execution.
In your case, enter the following calculation expression:
SERIALNUM = INCR(60000,1,A:PART_NUMBER)
In the above example:
Please note that all calculations are performed prior to sorting.