Mandatory
Specify whether the field is mandatory.
|
Value |
Description |
|---|---|
|
|
Sets the Field is mandatory. This is the default for primary key fields. |
|
|
Field is optional. |
Description
Primary key fields are mandatory, except in the following circumstances:
-
Primary key fields of an entity drawn as an up entity.
To make primary keys optional (non-mandatory), specify a minimum length of zero (0). However, this is not recommended because it contradicts the relational theory and can have unpredictable results.
-
Primary key fields in display-only entities (on a form with Behavior defined as Menu, or in entities for which Locking is No Updates). Because you cannot store any data in such cases, it is not important to make these primary keys mandatory.
Primary key fields are also mandatory in an up entity for which a ProcScript module has been defined in the writeUp trigger.
