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 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.