How to add a field which contains an incrementing serial

Modified on Tue, 09 Mar 2021 at 12:05 PM

To add a field which contains an incrementing Serial Numbers follow these instructions...
Step 1. Click the menu button top left of the EasyBadge program window.


Step 2. Click 'Modify Database' and then 'Add Field'.

Step 3. Select 'Text Field' and name it as required. In this example we have called the field 'Membership Number'. Click 'OK' and then click the 'Create' button and 'OK' a second time.

Step 4. Your database will need to close and re-open, click 'OK'.

Step 5. Now click the menu button again and select Modify Database > Modify Field and select the field you just added in the properties table change the default line to 'Identity(Id,1000,1)' as in the below example click on another line to refresh the window and click 'Save'.

This will start the numbering sequence at 1000 and go up in increments of 1 each time you add a new record. You can change these values to suit your needs. For Example Identity(Id,999001,3) Would produce this sequence > 999001, 999003, 999005, 999007 etc.