Setting Relationship Attributes

Previous Next

This section discusses relationship attributes other than identifying attributes (Parent Table, Child Table, Role, Parent Column, Child Column) and attributes that are merely textual (Co-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



See Also


Good Relationship Design

The RELATE keyword