Databases Reference
In-Depth Information
Figure 6-24.
Creating the master page
When dealing with a master-detail relationship, you normally have a foreign key between the detail and the
master tables. However, that may not always be the case. At the detail table step, the wizard allows you to choose
whether to show only tables that are related via a foreign key.
In this case, the tables are indeed linked, so you can leave Show Only Related Tables set to Yes.
7.
Select
TICKET_DETAILS
for
Table/View Name
. When the page refreshes, make sure the
following columns are moved to the Selected area to the right. You should end up with
results like those in Figure
6-25
.
•
TICKET_DETAILS_ID
•
TICKET_ID
•
DETAILS
•
CREATED_BY
•
CREATED_ON
•
ATTACHMENT
