Databases Reference
In-Depth Information
19.
Click
Next
.
20.
Set the
Tab Options
in Figure
6-29
to
Use an existing tab set and create a new tab within
the existing tab set
. When the page refreshes, set
Tab Set
to
TS1 (Home)
, enter
Tickets
for
New Tab Label
, and click
Next
.
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 report 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
region and selecting
Edit Report Attributes
, as shown in Figure
6-30
.