diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 20:50:52 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 20:50:52 +0000 |
| commit | 515c4034c19072e560ac9bb13f0f2b6e23395dca (patch) | |
| tree | d868281f8f5e884d346202686588d87eb2650efa /helpcontent2/source/text/shared/explorer/database/05020000.xhp | |
| parent | 5192963df3df7ca14f17f65677eb252ecdb4d77a (diff) | |
INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED
2004/10/15 08:44:26 fpe 1.1.2.3: Regular Updated
2004/10/11 09:48:49 fpe 1.1.2.2: Minor Corrections
2004/09/16 11:47:35 fpe 1.1.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database/05020000.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/explorer/database/05020000.xhp | 68 |
1 files changed, 37 insertions, 31 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/05020000.xhp b/helpcontent2/source/text/shared/explorer/database/05020000.xhp index 4f3cc7167b..3a8266175e 100644 --- a/helpcontent2/source/text/shared/explorer/database/05020000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05020000.xhp @@ -53,45 +53,51 @@ * * ************************************************************************--> + <helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05020000xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Relations</title> +<title id="tit" xml-lang="en-US">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> +<lastedited date="2004-10-08T15:22:24">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> +<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">Relations</link></paragraph> +<bookmark xml-lang="en-US" branch="index" id="bm_id3146957"><bookmark_value>relational databases</bookmark_value> +</bookmark> +<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="U" 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 Relationship</emph> icon to create the relationships, or simply drag-and-drop with the mouse.</paragraph> +<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00000450.xhp#relationen"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph> +<paragraph role="note" id="par_id3145316" xml-lang="en-US" l10n="U" oldref="3">This function is only available if you are working with a relational database.</paragraph> +<paragraph role="paragraph" id="par_id3149235" xml-lang="en-US" l10n="U" oldref="4">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 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</bookmark_value> +</bookmark> +<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> +<paragraph role="paragraph" id="par_id3152933" xml-lang="en-US" l10n="U" 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" 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> +<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"/> +<paragraph role="warning" id="par_id3153093" xml-lang="en-US" l10n="U" 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 role="paragraph" id="par_id3155856" xml-lang="en-US" 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> |