Database Reference
In-Depth Information
Figure 6-29.
Setting tab options
21. Confirm your selections, and click
Create
.
When the wizard completes, you have a working master-detail form on the
TICKETS
and
TICKET_DETAILS
tables, plus a report on the
TICKETS
table. This
is perhaps one report more than you expected, but APEX knows that in most cases, you
need the report to select the master-detail record to be edited, so that report is created at
the same time for convenience. The Master Detail Form Wizard created one report and
two forms, plus the links and branches for navigation and the processes for performing
database transactions. The Tickets report has a link to the Tickets form, which allows
editing of ticket master data and lists ticket details. The Ticket Details region on the
Manage Tickets page has an Edit link to the Ticket Detail form, where the user can add,
update, or delete ticket detail information. All the items, buttons, processes, and even
the column links were created by the Master Detail Form Wizard.
Again, although you can build a master-detail form and report manually, the wizard
is much faster and certainly more efficient. Now let's make some adjustments to the re-
port and the forms to suit your requirements.
Modifying a Master-Detail Report
Next, you modify the report to add CSV export capabilities, change the sorting options,
and modify the date format mask. Then you'll clean up the two edit forms. Here are the
steps:
1. Edit
Page 200
of your application.
2. Edit the report attributes by right-clicking the name of the
Tickets
re-
gion and selecting
Edit Report Attributes
, as shown in
Figure 6-30
.
