Databases Reference
In-Depth Information
4.
Click
Apply Changes
.
5.
Run the application and notice the difference in how the items are now aligned alongside
each other, as shown in Figure
6-67
.
Figure 6-67.
Manage Tickets form with corrected item alignment
Regardless of how the user resizes the Description text area, the Created By and Created On fields remain aligned.
Master-Detail Cleanup
You need to make a few more minor tweaks to the master-detail report and form. Let's start by hiding the
TICKET_ID
column from the detail report and form. At the detail level,
TICKET_ID
is the foreign key and should not be an editable item:
1.
Edit
Page 210
of the application.
2.
Edit the
Ticket Details
report attributes by right-clicking the region name and selecting
Edit Report Attributes
.
3.
Hide the
TICKET_ID
column by unchecking the value in the
Show
column.
4.
Enable sorting for the
DETAILS
,
CREATED_ON
, and
CREATED_BY
columns by selecting the
corresponding check boxes in the
Sort
column. These changes are shown in Figure
6-68
.
Figure 6-68.
Hiding the ticket ID and specifying Sort columns
