Example 3: Using the Set Field Macro Action The following code example shows a validation rule that resets the status of a line item when its quantity is increased.object to determine whether the value in the Quantity field was increased.There are also two height fields (call them A, B) for entering the numerical value (height) of plants in the different height classes (recorded in V, W, X, Y, Z).The issue is that plants in certain height classes (categories) should only be able to have certain heights.
The execution of the Macro action warns the user and cancels the event.
Input validation rules are rules that restrict what values can be entered into a database field.
You could, for example create an input validation rule that makes sure a number falls between .
Protecting the validity of your data is one of the most important tasks of a database developer.
To ensure that users enter accurate data, start at the foundation.