Page History
...
1. The iiiEmployees table should be open in the Editor. The Rules and trigger Trigger tab and Details tab should be visible.
2. Select the iiiSalary field in the list of rules.
3. In the Rules and Triggers group on the Home ribbon, expand the Add menu to select Add Range Check.
4. In the Details tab, create the rule as follows:
Description | Amount must be less than 10000 |
Sequence | 1 |
When Inserting | Always apply rule (ADD) |
When Updating | Apply when field is used (CHGUSE) |
When Feleting | Never apply rule |
From Value | 0.01 |
To Value | 10000 |
5. Complete the Actions section, to define the list check rule as follows:
If field is in the range of values | Evaluate next rule (NEXT) |
If field is NOT in range of values | Set field in error (ERROR) |
Message File | (delete the entry in this field) |
Message Number | (delete the entry in this field) |
Message Text | Amount must be less than 10,000 |
6. Save your table definition.