Delete Rule Options
The Delete Rule option field specifies how the deletion of rows is handled between the queries of a frame. The available options for Delete Rule are as follows:
Restrict (app)
Specifies that the application prevents the deletion of a master row if associated detail rows exist
Cascade (app)
Specifies that the application cascades the deletion of a master row by also deleting its associated detail rows
Restrict (dbms)
Specifies that the application assumes the presence of internal database rules that prevent the deletion of a master row if associated detail rows exist. The master row will be deleted if no such rules exist, orphaning its associated detail rows.
Cascade (dbms)
Specifies that the application assumes the presence of internal database rules that cascade the deletion of a master row by also deleting its associated detail rows. The master row will be deleted if no such rules exist, orphaning its associated detail rows.
None
Specifies that no delete rules are specified. The master row is deleted, regardless of whether there are associated detail rows.
The following sections illustrate in more detail how to create simple field, table field, master-detail, detail, and explosion frames. Subsequent sections describe how to add lookup, associate, and detail tables to your frame.