diff options
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database/05020000.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/explorer/database/05020000.xhp | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/05020000.xhp b/helpcontent2/source/text/shared/explorer/database/05020000.xhp new file mode 100644 index 0000000000..4f3cc7167b --- /dev/null +++ b/helpcontent2/source/text/shared/explorer/database/05020000.xhp @@ -0,0 +1,97 @@ +<?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 + * + * - GNU Lesser General Public License Version 2.1 + * - Sun Industry Standards Source License Version 1.1 + * + * Sun Microsystems Inc., October, 2000 + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2000 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + * + * Sun Industry Standards Source License Version 1.1 + * ================================================= + * The contents of this file are subject to the Sun Industry Standards + * Source License Version 1.1 (the "License"); You may not use this file + * except in compliance with the License. You may obtain a copy of the + * License at http://www.openoffice.org/license.html. + * + * Software provided under this License is provided on an "AS IS" basis, + * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, + * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. + * See the License for the specific provisions governing your rights and + * obligations concerning the Software. + * + * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. + * + * Copyright: 2000 by Sun Microsystems, Inc. + * + * All Rights Reserved. + * + * Contributor(s): _______________________________________ + * + * + ************************************************************************--> +<helpdocument version="1.0"> +<meta> +<topic id="textsharedexplorerdatabase05020000xml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Relations</title> +<filename>/text/shared/explorer/database/05020000.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +</history> +</meta> +<body> + + + <section id="relationen"> + <bookmark branch="hid/HID_CTL_RELATIONTAB" xml-lang="en-US" id="bm_id3153345"/><paragraph id="hd_id3153323" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><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</bookmark_value></bookmark><paragraph xml-lang="en-US" role="paragraph" id="par_id3146957" 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 l10n="U" xml-lang="en-US" role="paragraph" id="par_id3154823" oldref="19"><ahelp hid="HID_CTL_RELATIONTAB" visibility="visible">Here you can link together tables from the current database through common data fields.</ahelp> Click the <emph>New Relationship</emph> icon to create the relationships, or simply drag-and-drop with the mouse.</paragraph> + <paragraph role="paragraph" id="par_id3166460" l10n="E" xml-lang="en-US" oldref="" localize="false"><link href="text/shared/00/00000450.xhp#relationen" name=""><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph> + <paragraph role="note" id="par_id3145316" l10n="U" xml-lang="en-US" oldref="3">This function is only available if you are working with a relational database.</paragraph> + <paragraph xml-lang="en-US" oldref="4" l10n="U" role="paragraph" id="par_id3149235">If you click the <emph>Relation Design</emph> command in the context menu of the table container, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href="text/shared/02/14020100.xhp" name="Add Tables">Add Tables</link> dialog opens in which you can select the tables that you want.</paragraph> + <embed href="text/shared/00/00000450.xhp#sytabelle"/> + <paragraph xml-lang="en-US" role="note" id="par_id3152812" 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" l10n="U" xml-lang="en-US" 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 branch="index" xml-lang="en-US" id="bm_id3148922"><bookmark_value>primary keys;inserting</bookmark_value><bookmark_value>keys;primary keys</bookmark_value><bookmark_value>external keys</bookmark_value></bookmark><paragraph role="heading" level="2" id="hd_id3148922" l10n="U" xml-lang="en-US" oldref="6">Primary key and other key</paragraph> + <paragraph xml-lang="en-US" role="paragraph" id="par_id3149168" 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" l10n="U" xml-lang="en-US" oldref="8">All data fields referring to a primary key will be identified in the table window by a small key symbol.</paragraph> + <paragraph role="paragraph" id="par_id3152933" l10n="U" xml-lang="en-US" oldref="9">For example, consider the "Item" table, where each individual record can be defined by an item number. The "Item-Number" field is a unique key in this table, and is referred to as a "primary key".</paragraph> + <paragraph role="paragraph" id="par_id3158410" l10n="U" xml-lang="en-US" 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" l10n="U" xml-lang="en-US" 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" level="2" id="hd_id3153193" l10n="U" xml-lang="en-US" oldref="12">Define relations</paragraph> + <bookmark branch="index" xml-lang="en-US" id="bm_id3155430"><bookmark_value>relations; creating</bookmark_value><bookmark_value>relations; deleting</bookmark_value></bookmark><paragraph role="paragraph" id="par_id3155430" l10n="U" xml-lang="en-US" 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 xml-lang="en-US" oldref="18" role="paragraph" id="par_id3149984" l10n="U">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"/> + <paragraph role="warning" id="par_id3153093" l10n="U" xml-lang="en-US" oldref="14">If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the external database.</paragraph> + <paragraph xml-lang="en-US" role="paragraph" id="par_id3155856" l10n="U" oldref="15">By double-clicking a connection line, you can assign certain properties to the relation. The <emph>Relations </emph>dialog opens.</paragraph> + + + </body> +</helpdocument> |