REP003 - Validation Rules

Validation rules are enforced by business rules defined in the Repository. Rules which are defined in the field definition become global rules, meaning that they will be enforced in any table where the field is used.
Most rules are defined in the table definition. They are enforced only in the context of that table.
You will learn more about Validation Rules in REP007 - Table Validation Rules/Triggers.

Objectives

• To show field level validation rules in the repository.

• To show how rules are adopted from reference fields.

• To add the following business rules to the fields:

iiiSurname Cannot be blank (copied from reference field) iiiSalary Must be greater than 0

To achieve these objectives, you will complete the following:

Step 1. Review Existing Rule for Field iiiDeptCode

Step 2. Adopt Rule from Reference Field

Step 3. Create a Rule for the iiiSalary Field

Summary

Before you Begin

In order to complete this exercise, you must have completed the previous exercises.