When Auto Numbering is enabled, with mask options, you may set the auto numbering to be keyed to the reference number (loan ref#) of the loan, or to a key that you set, which will iterate as each loan is added.


The mask is formatted as follows: aaa%n#dbbb

where:

aaa = a string of characters to be placed at the beginning of the loan number (prefix)

% = the actual character "%" sets off the starting string from what follows

n = any single character after the percent sign is used to designate which character will be used to pad the number (refno or key)

# = a number which indicates how many digits to pad

d = the actual character "d" indicates where the refno or key is to go, and it is padded based on the number which proceeds it and the character proceeding that number

bbb = a string of characters to be placed at the end of the loan number (suffix)


EXAMPLE: if the mask were set to THX%05d-R2D2 and the current key was 1138, then the next loan or contact number assigned would be THX01138-R2D2.



To set the auto numbering to be keyed to the reference number of the loan, Check the Use ROWID box.

Example - If the settings are set up as follows...


... the next loan added will match its Loan Ref#:


If the Use ROWID box is unchecked, then you may enter a number into the Current Key field.  So in the next example, the Current Key is set to 111.


The next loan number added will be 111, and the one after that will be 112



If you wish to add a prefix to the loan number, enter it ahead of the “%d” in the Mask field. 

For instance, if you wanted your loan numbers to start with NLS000, you would  enter:



The next loan number will be NLS000113, and the one after that would be NLS000114