Contents of the Numbering Form

You can set up auto numbering for records in the hubs. When you create a user-defined hub that includes a Number field, a row is added to the Numbering tab, and you can define the numbering structure for the new hub.

To change the length and format of key fields, use the Key Formats utility.

System Numbering Format Grid

Field Description
System Label This column displays the system label of the record.
Length This column displays the length, in characters, of the record's number field. If the number has delimiters, they are included in this length.
Leading Zeros This Yes/No field indicates whether or not the number includes leading zeros.
First Delimiter This column displays the character of the first delimiter.
First Delimiter Position This column displays the location of the first delimiter.
Second Delimiter This column displays the position of the second delimiter.
Second Delimiter Position This column displays the location of the second delimiter.
Auto Number Source If you use automatic numbering, select one of the following options as the source for the auto numbering. These options let you create custom formulas for your auto numbers or disable auto numbering.
  • Expression
  • Stored Procedure
  • Web Service
  • <None>: Select this option to disable auto numbering for the associated hub.
Auto Number Format If you select an auto numbering source in the Auto Number Source column, this column is enabled and required. Click in this column and then click the hour glass icon to open the Expression Configuration dialog box. The contents of the dialog box reflect your selection in the Auto Number Source column.

After you define a format, <auto number defined> displays in this column.

Allow Override of Auto Number Select the check box in this column to allow the user to enter a different number before the record is saved and the auto number is generated for a record.

If an auto number has been generated, you must run a Key Conversion to change the number.