Topic group

If supported by the database type, you may be able to specify data-entry constraints—rules that govern the values you can enter in a field. If you want to make sure that the values users enter in a field meet certain conditions, specify a data-entry constraint for that field.

You can specify data-entry constraints for each field in the Inspector when you create or modify a table that supports them, such as a dBASE or a Paradox table.

The Inspector displays different data-entry constraints depending on the field type.

Validity check

Meaning

Required

Every row in the table must have a value in this field.

Minimum

The values entered in this field must be equal to or greater than the minimum you specify here.

Maximum

The values entered in this field must be less than or equal to the maximum you specify here.

Default

The value you specify here is automatically entered in this field. You can replace it with another value.