Database 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
Figure 6-25.
Defining the detail table
