Optional Relationships

Which side of the relationship do you want to make optional?

If you want the parent-side to be optional, then

1. Click the child table.
2. Switch to the Columns category.
3. Un-check the Req'd property of the foreign key field.

If you want the child-side to be optional, then

1. Click the relationship between the tables .
2. Switch to the Miscellaneous category.
3. Select the "zero or more" cardinality. (Select "one or more" if you want all parents to have at least one child.)

More FAQs