Database Reference
In-Depth Information
Figure 11.16
shows the settings you've made within the Logical Elements category of the
Field Specifications sheet for this field.
Figure 11.16. Setting the Logical Elements category for the S
TATE
foreign key field in
the SUPPLIERS table
Now you must decide which actions test the rule. When you use a validation table to en-
force a business rule, you typically want to test the rule when a user attempts to
insert
a
new value into the field or
update
an existing value within the field. In either case, a viola-
tion will occur when the user attempts to enter a value that does not exist in the validation
table.
Finally, fill out a Business Rule Specifications sheet for the business rule you've just es-
tablished. Be sure to indicate the modifications you've made to
both
the field and the new
relationship.
Figure11.17
showsthecompletedBusinessRuleSpecificationssheetforyour
new rule.