Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_frm_detail.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Creating a Master Detail Form</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:29Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Creating a Master Detail Form" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="app_comp.htm" title="Adding Application Components" type="text/html" /> <link rel="up" href="bldapp_frm.htm" title="Creating Forms" type="text/html" /> <link rel="up" href="bldapp_frm_detail.htm" title="Creating a Master Detail Form" type="text/html" /> <link rel="prev" href="bldapp_frm_tab.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_frm_manual.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="app_comp.htm" title="Adding Application Components">Adding Application Components</a> > <a href="bldapp_frm.htm" title="Creating Forms">Creating Forms</a> > Creating a Master Detail Form</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="bldapp_frm_tab.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm_manual.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEBEDIC" name="BCEBEDIC"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB05036|form, master detail"></a>Creating a Master Detail <a id="sthref1075" name="sthref1075"></a><a id="sthref1076" name="sthref1076"></a>Form</h1> <p>A master detail form reflects a one-to-many relationship between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. With this form, users can insert, update, and delete values from two tables or views.</p> <p>To create a master detail form:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select an application.</p> </li> <li> <p>Click <span class="bold">Create Page</span>.</p> </li> <li> <p>Select <span class="bold">Form</span> and click <span class="bold">Next</span>.</p> </li> <li> <p>Select <span class="bold">Master Detail Form</span> and click <span class="bold">Next</span>.</p> <p>The Master Detail Wizard appears.</p> </li> <li> <p>On Master Table:</p> <ol> <li> <p>Select the table or view owner.</p> </li> <li> <p>Select a table or view name.</p> <p>The columns in that object appear under Available Columns.</p> </li> <li> <p>Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>On Detail Table:</p> <ol> <li> <p>Specify whether to show only related tables by selecting <span class="bold">Yes</span> or <span class="bold">No</span>.</p> </li> <li> <p>Select the table or view owner.</p> </li> <li> <p>Select a table or view name.</p> <p>The columns in that object appear under Available Columns.</p> </li> <li> <p>Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>On Primary Key:</p> <ol> <li> <p>Primary Key(s) of Master Table - Select the primary key (or keys) of the master table. You can select maximum of two primary keys for master table.</p> </li> <li> <p>Primary Key(s) of Detail Table - Select the primary key (or keys) of the detail table. You can select maximum of two primary keys for detail table.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>On Master Detail Link, define the relationship between the master and detail tables and click <span class="bold">Next</span>.</p> </li> <li> <p>On Primary Key Source, select the primary key column for the master table and click <span class="bold">Next</span>. Then select the primary key column for the detail table and click <span class="bold">Next</span>. Options include:</p> <ul> <li> <p><span class="bold">Existing trigger</span> - Select this option if a trigger is defined to populate the primary key, or if the user will be expected to enter the primary key value manually. Detail tables do not support user entered primary key values.</p> </li> <li> <p><span class="bold">Custom PL/SQL function</span> - Select this option if you want to provide a PL/SQL function to populate the primary key.</p> </li> <li> <p><span class="bold">Existing sequence</span> - Select this option if an existing sequence will be used to generate the primary key.</p> </li> </ul> </li> <li> <p>On Master Options, specify whether to include master row navigation and click <span class="bold">Next</span>.</p> <p>If you include master row navigation, define navigation order columns. If a navigation order column is not defined, the master update form navigates by the primary key column.</p> </li> <li> <p>On Layout, specify how to build the master detail and click <span class="bold">Next</span>. Options include:</p> <ul> <li> <p><span class="bold">Edit detail as tabular form on same page</span> creates a two page master detail. Edit detail on separate page creates a three page master detail.</p> </li> <li> <p><span class="bold">Edit detail on separate page</span> creates a three page master detail.</p> </li> </ul> </li> <li> <p>On Page Attributes, review and edit the master page and detail page information and then click <span class="bold">Next</span>.</p> </li> <li> <p>On Tab, specify whether to include a tab set and click <span class="bold">Next</span>.</p> </li> <li> <p>Click <span class="bold">Create</span>.</p> </li> </ol> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="bldapp_frm_tab.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm_manual.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de