Translation

05010100.xhp hd_id3155132 help.text
English cEYAF
Context English Chinese (Simplified) Actions
05010100.xhp
par_id3148685
help.text
<ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME">Renames the current index.</ahelp>
05010100.xhp
hd_id3153628
help.text
Save Current Index
05010100.xhp
par_id3148563
help.text
<ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE">Saves the current index in the data source.</ahelp>
05010100.xhp
hd_id3154924
help.text
Reset Current Index
05010100.xhp
par_id3154758
help.text
<ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RESET">Resets the current index to the setting that it had when the dialog was started.</ahelp>
05010100.xhp
hd_id3152812
help.text
Index details
05010100.xhp
par_id3154938
help.text
As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.
05010100.xhp
hd_id3154138
help.text
Unique
05010100.xhp
par_id3156282
help.text
<ahelp hid="dbaccess/ui/indexdesigndialog/UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity.
05010100.xhp
hd_id3150448
help.text
Fields
05010100.xhp
par_id3147085
help.text
The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.
05010100.xhp
hd_id3149765
help.text
Index field
05010100.xhp
par_id3158408
help.text
<ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp>
05010100.xhp
hd_id3153192
help.text
Sort order
05010100.xhp
par_id3149561
help.text
<ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order of the indexes.</ahelp>
05010100.xhp
hd_id3155132
help.text
Close
05010100.xhp
par_id3154190
help.text
<ahelp hid="dbaccess/ui/indexdesigndialog/close">Closes the dialog.</ahelp>
05020000.xhp
tit
help.text
Relations
05020000.xhp
hd_id3153323
help.text
<link href="text/sdatabase/05020000.xhp" name="Relations">Relations</link>
05020000.xhp
bm_id3146957
help.text
<bookmark_value>relational databases (Base)</bookmark_value>
05020000.xhp
par_id3146957
help.text
This command opens the <emph>Relation Design </emph>window, which allows you to define relationships between various database tables.
05020000.xhp
par_id3154823
help.text
<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.
05020000.xhp
par_id3145316
help.text
This function is only available if you are working with a relational database.
05020000.xhp
par_id3149235
help.text
When you choose <emph>Tools - Relationships</emph>, 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 on 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 with which to create a relation.
05020000.xhp
par_id3152812
help.text
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.
05020000.xhp
par_id3150541
help.text
The selected tables are shown in the top area of the relation design view. You can close a table window through the context menu or with the Delete key.
05020000.xhp
bm_id3148922
help.text
<bookmark_value>primary keys;inserting (Base)</bookmark_value><bookmark_value>keys;primary keys (Base)</bookmark_value><bookmark_value>external keys (Base)</bookmark_value>
05020000.xhp
hd_id3148922
help.text
Primary key and foreign keys
05020000.xhp
par_id3149168
help.text
If you want to define a relation among the various tables, you should enter a <link href="text/shared/00/00000005.xhp#primary_key" name="primary key">primary key</link> that uniquely identifies a data field of an 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 a foreign key.
05020000.xhp
par_id3147085
help.text
All data fields referring to a primary key will be identified in the table window by a small key symbol.
05020000.xhp
hd_id3153193
help.text
Define relations
User avatar hxlpdd

Suggestion added

Suggested change:

4 months ago
Component Translation Difference to current string
This translation Propagated Empty LibreOffice Help - master/text/sdatabase
The following strings have different contexts, but the same source.
Translated LibreOffice Help - master/text/swriter/01 关闭
Translated LibreOffice Help - master/text/swriter/01 关闭
Translated LibreOffice Help - master/text/shared/00 关闭
Translated LibreOffice Help - master/text/shared/00 关闭
Translated LibreOffice Help - master/text/shared/01 关闭
Translated LibreOffice Help - master/text/shared/01 关闭
Translated LibreOffice Help - master/text/shared/02 关闭
Translated LibreOffice Help - master/text/shared/02 关闭
Translated LibreOffice Help - master/text/swriter/01 关闭
Translated LibreOffice Help - master/text/shared/02 关闭

Loading…

User avatar hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

4 months ago
Browse all component changes

Things to check

Suggestions

There is 1 suggestion for this string.

View

Glossary

English Chinese (Simplified)
No related strings found in the glossary.

String information

Context
05010100.xhp
hd_id3155132
help.text
Source string description
cEYAF
Source string location
05010100.xhp
String age
a year ago
Source string age
a year ago
Translation file
zh-CN/helpcontent2/source/text/sdatabase.po, string 414