Validating yourself

During the creation of a foreign key, you put your cursor on the foreign key field and pressed the foreign key button, and the system generated a foreign key proposal consisting of pairs of fields.

In each pair, one field comes from the check table and the other from the foreign key table.

validating yourself-77

The Status fields contain the values After you have created a foreign key, the name of the check table appears in the Check Table column on the Dictionary: Table/Structure screen.

If a field is a foreign key, the Check Table column will contain the name of the check table for that field. You should see the name of your check table in the Check Table column.

Because these fields share a common domain, the integrity of the comparison between the two fields is guaranteed because their data types and lengths will always match.

Now it is time for you to create a simple foreign key.

When you created the foreign key, you did not have to specify the fields that should participate in the foreign key relationship-the system determined it automatically.

This section explains how the system determines these field names.

A foreign key is a field in a table that is connected to another table via a foreign key relationship.

The purpose of the foreign key relationship is to validate the data being entered into one table by checking against a valid set of values in another table.

Before you create a foreign key, you must first have a check table.

Tags: , ,