If the primary key field has the data type 'Number', this key can be automatically incremented by the DP4 system. A multi-part key can also be incremented in this way, provided that the last part of the key is a number. If you use this feature, then each time a user enters a new record, DP4 supplies the next number in the sequence. For example, for the CUSTOMER table in the example Sales Order database, the customer number is allocated automatically.
In a multi-user system, the numbers remain contiguous, even if users abandon half-completed transactions.