Database Reference
In-Depth Information
CATEGORIES table. You must now make certain that the C
ATEGORY
ID field in the
PRODUCTStableconformstotheElementsofaForeignKeyandthenmaketheappropri-
ate modifications to its field specification. Finally, set the field's Range of Values element
to something such as this:
Any value within the C
ATEGORY
ID field in the CATEGORIES
table.
Figure 11.19
shows the settings you've made to the Logical Elements category of the field
specifications for the C
ATEGORY
ID field in the PRODUCTS table.
Figure 11.19. Logical Elements settings for the C
ATEGORY
ID foreign key field in the
PRODUCTS table
Now you must decide when the rule should be tested. As you already know, you typically
want to test a rule established with a validation table if the user attempts to insert a value
into the field or update an existing value within the field.