Relationship attributes

Previous Next

This section discusses relationship attributes other than identifying attributes (Parent Table, Child Table, Parent Role, Parent Column, Child Column) and attributes that are merely textual (Child Role, Lookup Window Name, Related Window Name).

The attributes discussed may be set by clicking the Relationship Details tab in the Relationship window.

 

 

collapseForeign Key Mandatory
collapseCheck Partial Foreign Key
collapseLock Foreign Key on Check
collapseForeign Key Updatable
collapseChild Must Exist
collapseMinimum Children
collapseMaximum Children
collapseLookup Method
collapseDelete Rule
collapseUpdate Rule
collapseType Of Relationship

 

See also

Relationships

Mapping associations to Tables, Columns and Relationships

How to define a Relationship

The RELATE keyword