An auto-generated sequence value for a repository is controlled by the corresponding sequence definition associated to the repository. When a new record is created in the repository and no value for the auto generated id field is provided, the next sequence number is selected from the sequence definition. Even though a sequence definition can be shared by multiple repositories, it is recommended as best practice to create a separate sequence definition for each repository. A repository sequence definition is defined as follows:
Log into EnterWorks Classic as a user assigned to the Administrator group.
Select Repositories from the Quick Links dropdown list on the top right of the screen, or you can open the Feature bar, open the Model tab, and select Repositories.
From the Repository list, single-click to select the repository record that contains the auto-generated sequence attribute.
Select the Edit/Properties option from the Action drop-down menu. The Properties editor will appear.
Select the Auto Generate Sequence checkbox.
Click the Manage button next to the Sequence drop-down list (above the Auto Generate Sequence checkbox) to create a new sequence definition.
NOTE: Sequence definitions can also be accessed via the Model Configurations / Sequences option on the Feature bar.
Enter a Name and Starting Sequence Number for the sequence number definition. Do not include special characters in the name, such as & < > ".
Click the Save button.