I - Specific features
-
To open the advanced options of an I field, click on File to go to the backstage section, in Database, click Edit fields.
-
Select the right table and double click on the I field.
-
Go to step 2 of the wizard and click on the Advanced options button.Default value: this value will be automatically inserted when creating a new record (default value is ?).Minimum value: user cannot enter a value smaller than the minimum value.Maximum value: user cannot enter a value higher than the maximum value.Note: default value is 0 for both (minimum and maximum value) which means no restrictions in terms of value.
4. Click OK to save the settings.