Item 

Description 

Name  

Specify the name of the relation.  

Parent table  

Specify the parent table in the relation.  

Child table  

Specify the child table in the relation.  

Key Columns  

Select one or more columns to act as the primary key in the parent table.  

Foreign Key Columns  

Select one or more columns to act as the foreign key in the child table. Typically, these must correspond to the columns you chose as your primary key, if not in name, then by data type and value.  

Update rule  

Select the Update rule to use when updating records. Applies to master-detail relationships and how detail records are updated when a master record is updated.  

Delete rule  

Select the Delete rule to use when deleting records. Applies to master-detail relationships and how detail records are deleted when a master record is deleted.  

Accept/Reject rule  

Select the Accept/Reject rule to use when an insert occurs in a master-detail relationship.