Databases Reference
In-Depth Information
4.
Expand the following node: Employee
Regions
Body (3)
EMPLOYEE
Report Columns, right click on the SOCIALSECURITYNO field, and click on
the Create Validation submenu item, as shown in Figure 3-6.
Figure 3-6.
Adding validation to the SOCIALSECURITYNO field
5.
On the next page, choose the Column Not Null validation type (you are
checking to ensure SocialSecurityNo field is not left empty). Use the default
settings on the next page.
6.
On the page after that, you will be allowed to specify the error message shown
if the validation fails. Enter the following error message: “Please specify the
employee's Social Security number.”
7.
In the next page, choose ADD (Add Row) for the When Button Pressed field.
Save the changes and run your tabular form. Leave the Social Security number
field empty and try to submit the tabular form. You should see the screen
shown in Figure 3-7.
