Record validation
Data entered into fields is validated by
- The data entered into a field is appropriate for that field, i.e. a date has been entered in a date field.
- Mandatory fields have been completed. If a mandatory field has been missed, you'll be prompted to go back and complete it.
- A value cannot be added to a read-only Lookup List. If a value has been entered into a read-only Lookup List field and that value is not already in the Lookup List, you will be prompted to go back and select an existing value.
Only after the record passes validation is it added to the database.
Validation is performed on:
Subject to validation: |
Explanation |
---|---|
A value must be entered into every mandatory field. If not, you will be prompted to go back and complete the field before the record can be saved. |
|
A Lookup List can be set up so that only users with appropriate access can add new values. If a value is added that is not in the Lookup List, you will be prompted to change or save the value depending on what permissions you have been granted. |
|
A new hierarchy combination may generate several prompts so that you must validate each new level of the hierarchy. |