diff options
| author | Jens-Heiner Rechtien <hr@openoffice.org> | 2006-08-14 14:26:32 +0000 |
|---|---|---|
| committer | Jens-Heiner Rechtien <hr@openoffice.org> | 2006-08-14 14:26:32 +0000 |
| commit | 182f39448ea52a638282844f0f2eda9f23bb815a (patch) | |
| tree | fd685fceedd61aa868c72ff51292aa6539f81a02 /helpcontent2/source/text/shared/explorer/database/05020000.xhp | |
| parent | 2ccc97265c9a88470b6826997cd7fdd652cfcb3f (diff) | |
INTEGRATION: CWS hcshared01 (1.4.64); FILE MERGED
2006/05/30 15:12:19 ufi 1.4.64.2: RESYNC: (1.4-1.7); FILE MERGED
2006/03/24 13:50:14 ufi 1.4.64.1: *** empty log message ***
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database/05020000.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/explorer/database/05020000.xhp | 26 |
1 files changed, 14 insertions, 12 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/05020000.xhp b/helpcontent2/source/text/shared/explorer/database/05020000.xhp index d9be177d37..97c5ac5962 100644 --- a/helpcontent2/source/text/shared/explorer/database/05020000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05020000.xhp @@ -1,5 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** +<!-- + *********************************************************************** * * The Contents of this file are made available subject to the terms of * either of the following licenses @@ -52,7 +53,8 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--> + ************************************************************************ + --> <helpdocument version="1.0"> <meta> @@ -62,15 +64,15 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-22T09:51:36">converted from old format - fpe</lastedited> +<lastedited date="2006-02-28T10:37:28">converted from old format - fpe</lastedited> </history> </meta> <body> <section id="relationen"> <bookmark xml-lang="en-US" branch="hid/HID_CTL_RELATIONTAB" id="bm_id3153345" localize="false"/> -<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05020000.xhp" name="Relations">Relationships</link></paragraph> -<bookmark xml-lang="en-US" branch="index" id="bm_id3146957"><bookmark_value>relational databases</bookmark_value> -</bookmark> +<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05020000.xhp" name="Relations">Relations</link></paragraph> +<bookmark xml-lang="en-US" branch="index" id="bm_id3146957"><bookmark_value>relational databases (Base)</bookmark_value> +</bookmark><comment>mw added "(Base)"</comment> <paragraph role="paragraph" id="par_id3146957" xml-lang="en-US" l10n="U" oldref="2">This command opens the <emph>Relation Design </emph>window, which allows you to define relationships between various database tables.</paragraph> </section> <paragraph role="paragraph" id="par_id3154823" xml-lang="en-US" l10n="CHG" oldref="19"><ahelp hid="HID_CTL_RELATIONTAB">Here you can link together tables from the current database through common data fields.</ahelp> Click the <emph>New Relation</emph> icon to create the relationships, or simply drag-and-drop with the mouse.</paragraph> @@ -81,10 +83,10 @@ <paragraph role="note" id="par_id3152812" xml-lang="en-US" l10n="U" oldref="17">If the <emph>Relation Design</emph> window is open, the selected tables cannot be modified, even in Table Design mode. This ensures that tables are not changed while the relations are being created.</paragraph> <paragraph role="paragraph" id="par_id3150541" xml-lang="en-US" l10n="U" oldref="5">The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key.</paragraph> <embed href="text/shared/explorer/database/02010100.xhp#darstellungaendern"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148922"><bookmark_value>primary keys;inserting</bookmark_value> -<bookmark_value>keys;primary keys</bookmark_value> -<bookmark_value>external keys in relational databases</bookmark_value> -</bookmark> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148922"><bookmark_value>primary keys;inserting (Base)</bookmark_value> +<bookmark_value>keys;primary keys (Base)</bookmark_value> +<bookmark_value>external keys (Base)</bookmark_value> +</bookmark><comment>mw added "(Base)" to all entries</comment> <paragraph role="heading" id="hd_id3148922" xml-lang="en-US" level="2" l10n="U" oldref="6">Primary key and other key</paragraph> <paragraph role="paragraph" id="par_id3149168" xml-lang="en-US" l10n="U" oldref="7">If you want to define a relation among the different tables, you should enter a <link href="text/shared/00/00000005.xhp#primaerschluessel" name="primary key">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key.</paragraph> <paragraph role="paragraph" id="par_id3147085" xml-lang="en-US" l10n="U" oldref="8">All data fields referring to a primary key will be identified in the table window by a small key symbol.</paragraph> @@ -92,8 +94,8 @@ <paragraph role="paragraph" id="par_id3158410" xml-lang="en-US" l10n="U" oldref="10">There is an additional table with the name "Orders" in the database. The number of the ordered item is assigned to each record in this table through an "Item-Number" field. This field is also a key field. It contains a key used to access the records of another table, in this case the "Item" table. For this reason, this field is referred to as the "foreign key".</paragraph> <paragraph role="paragraph" id="par_id3151177" xml-lang="en-US" l10n="U" oldref="11">A relation is used to relate the primary key of the "Article" sheet and the other key of the "Orders" sheet.</paragraph> <paragraph role="heading" id="hd_id3153193" xml-lang="en-US" level="2" l10n="U" oldref="12">Define relations</paragraph> -<bookmark xml-lang="en-US" branch="index" id="bm_id3155430"><bookmark_value>relations; creating and deleting</bookmark_value> -</bookmark> +<bookmark xml-lang="en-US" branch="index" id="bm_id3155430"><bookmark_value>relations; creating and deleting (Base)</bookmark_value> +</bookmark><comment>mw added "(Base)"</comment> <paragraph role="paragraph" id="par_id3155430" xml-lang="en-US" l10n="U" oldref="13">All existing relations are shown in the relations windows by a line that connects the primary and other key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key.</paragraph> <paragraph role="paragraph" id="par_id3149984" xml-lang="en-US" l10n="U" oldref="18">Alternatively, you can also click the <emph>New Relation</emph> icon in the top area of the relation field and define the relation between two tables in the <link href="text/shared/explorer/database/05020100.xhp" name="Relations"><emph>Relations</emph></link> dialog.</paragraph> <embed href="text/shared/00/00000450.xhp#SyRelationen"/> |