diff options
Diffstat (limited to 'source/text/shared/02/01170102.xhp')
| -rw-r--r-- | source/text/shared/02/01170102.xhp | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/source/text/shared/02/01170102.xhp b/source/text/shared/02/01170102.xhp index 65a442d865..0194f0c3ff 100644 --- a/source/text/shared/02/01170102.xhp +++ b/source/text/shared/02/01170102.xhp @@ -34,13 +34,13 @@ <bookmark_value>links;between cells and controls</bookmark_value> <bookmark_value>controls;assigning data sources</bookmark_value> </bookmark><comment>MW made "cells..." a two level entry, changed "linked cells;" to "links;" and "list contents" to "lists;"</comment> -<h1 id="hd_id3155413"><link href="text/shared/02/01170102.xhp" name="Data">Data</link></h1> +<h1 id="hd_id3155413"><link href="text/shared/02/01170102.xhp">Data</link></h1> <paragraph role="paragraph" id="par_id3155306" xml-lang="en-US">The <emph>Data</emph> tab page allows you to assign a data source to the selected control.</paragraph> </section> <section id="howtoget"> <embed href="text/shared/00/00040501.xhp#control_properties_data"/> </section> -<note id="par_id3148773">For forms with database links, the associated database is defined in the <link href="text/shared/02/01170200.xhp" name="Form Properties"><emph>Form Properties</emph></link>. You will find the functions for this on the <link href="text/shared/02/01170203.xhp" name="Data"><emph>Data</emph></link> tab page.</note> +<note id="par_id3148773">For forms with database links, the associated database is defined in the <link href="text/shared/02/01170200.xhp"><emph>Form Properties</emph></link>. You will find the functions for this on the <link href="text/shared/02/01170203.xhp"><emph>Data</emph></link> tab page.</note> <paragraph role="paragraph" id="par_id3149377" xml-lang="en-US">The possible settings of the <emph>Data</emph> tab page of a control depend on the respective control. You will only see the options that are available for the current control and context.<br/>The following fields are available:</paragraph> <sort order="asc" descendant="h2"> <section id="Section10"> @@ -75,11 +75,11 @@ </list> <list type="ordered"> <listitem> - <paragraph role="listitem" id="par_id3153949" xml-lang="en-US">Third case: <link href="text/shared/02/01170900.xhp" name="Combo Boxes">Combo Boxes</link></paragraph> + <paragraph role="listitem" id="par_id3153949" xml-lang="en-US">Third case: <link href="text/shared/02/01170900.xhp">Combo Boxes</link></paragraph> <paragraph role="listitem" id="par_id3147494" xml-lang="en-US">For combo boxes, the field of the data source table in which the values entered or selected by the user should be stored is specified under <emph>Data field</emph>. The values displayed in the list of the combo box are based on an SQL statement, which is entered under <emph>List content</emph>.</paragraph> </listitem> <listitem> - <paragraph role="listitem" id="par_id3145167" xml-lang="en-US">Fourth case: <link href="text/shared/02/01170900.xhp" name="List Boxes">List Boxes</link></paragraph> + <paragraph role="listitem" id="par_id3145167" xml-lang="en-US">Fourth case: <link href="text/shared/02/01170900.xhp">List Boxes</link></paragraph> <paragraph role="listitem" id="par_id3153764" xml-lang="en-US">The data source table does not contain the data to be displayed, but rather a table linked to the data source table through a common data field.</paragraph> <paragraph role="listitem" id="par_id3149021" xml-lang="en-US">If you want a list box to display data from a table that is linked to the current data source table, under <emph>Data field</emph> specify the field of the data source table to which the content of the list box refers. Or you can specify the database field that controls the display of the data in the form. This data field provides the link to the other table if both tables can be linked through a common data field. It is usually a data field in which unique identification numbers are stored. The data field whose contents are displayed in the form is specified by an SQL statement under <emph>List content</emph>.</paragraph> </listitem> @@ -92,7 +92,7 @@ <paragraph role="paragraph" id="par_id3154967" xml-lang="en-US">where "CustomerName" is the data field from the linked table "Customers", and "CustomerNo" is the field of the table "Customers" that is linked to a field of the form table "Orders" specified under <emph>Data field</emph>.</paragraph> <paragraph role="paragraph" id="par_id3163808" xml-lang="en-US"><emph>References Using Value Lists</emph></paragraph> <paragraph role="paragraph" id="par_id3145295" xml-lang="en-US">For list boxes, you can use value lists. Value lists are lists that define reference values. In this way, the control in the form does not directly display the content of a database field, but rather values assigned in the value list.</paragraph> -<paragraph role="paragraph" id="par_id3151186" xml-lang="en-US">If you work with reference values of a value list, the contents of the data field that you specified under <emph>Data Field</emph> in the form are not visible, but rather the assigned values. If you chose "Valuelist" on the <emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a reference value to the visible list entries in the form under <emph>List entries</emph> (entered in the <link href="text/shared/02/01170101.xhp" name="General"><emph>General</emph></link> tab), then the reference values are compared with the data content of the given data field. If a reference value corresponds to the content of a data field, the associated list entries are displayed in the form.</paragraph> +<paragraph role="paragraph" id="par_id3151186" xml-lang="en-US">If you work with reference values of a value list, the contents of the data field that you specified under <emph>Data Field</emph> in the form are not visible, but rather the assigned values. If you chose "Valuelist" on the <emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a reference value to the visible list entries in the form under <emph>List entries</emph> (entered in the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab), then the reference values are compared with the data content of the given data field. If a reference value corresponds to the content of a data field, the associated list entries are displayed in the form.</paragraph> </section> <section id="Section2"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN" id="bm_id3150297" localize="false"/> @@ -185,7 +185,7 @@ <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE" id="bm_id3153316" localize="false"/> <h2 id="hd_id3149772">Type of list contents</h2> <paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"><ahelp hid="." visibility="hidden">Determines the data to fill the lists in list and combo boxes.</ahelp> Determines the data to fill the lists in list and combo boxes.</paragraph> - <paragraph role="paragraph" id="par_id3153326" xml-lang="en-US">With the "Valuelist" option, all entries entered in the <emph>List entries</emph> field of the <link href="text/shared/02/01170101.xhp" name="General"><emph>General</emph></link> tab appear in the control. For database forms, you can use reference values (see the <link href="text/shared/02/01170102.xhp" name=" References Using Value Lists"><emph>References Using Value Lists</emph></link> section).</paragraph> + <paragraph role="paragraph" id="par_id3153326" xml-lang="en-US">With the "Valuelist" option, all entries entered in the <emph>List entries</emph> field of the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab appear in the control. For database forms, you can use reference values (see the <link href="text/shared/02/01170102.xhp"><emph>References Using Value Lists</emph></link> section).</paragraph> <paragraph role="paragraph" id="par_id3153067" xml-lang="en-US">If the content of the control is read from a database, you can determine the type of the data source with the other options. For example, you can choose between tables and queries.</paragraph> </section> <section id="Section4"> @@ -202,7 +202,7 @@ <paragraph role="paragraph" id="par_id3154344" xml-lang="en-US">Here "field" is a data field from the list table "table" whose content is displayed in the list of the combo box.</paragraph> <paragraph role="paragraph" id="par_id3149328" xml-lang="en-US"><emph>Value lists for HTML documents</emph></paragraph> <paragraph role="paragraph" id="par_id3156034" xml-lang="en-US">For HTML forms, you can enter a value list under <emph>List content</emph>. Select the option "Valuelist" under <emph>Type of list contents</emph>. The values entered here will not be visible in the form, and are used to assign values to the visible entries. The entries made under <emph>List content</emph> correspond to the HTML tag <OPTION VALUE=...>.</paragraph> - <paragraph role="paragraph" id="par_id3154855" xml-lang="en-US">In the data transfer of a selected entry from a list box or a combo box, both the list of the values displayed in the form, which was entered on the <link href="text/shared/02/01170101.xhp" name="General"><emph>General</emph></link> tab under <emph>List entries</emph>, and the value list entered on the <emph>Data</emph> tab under <emph>List content</emph>, are taken into consideration: If a (non-empty) text is at the selected position in the value list (<OPTION VALUE=...>), it will be transmitted. Otherwise, the text displayed in the (<OPTION>) control is sent.</paragraph> + <paragraph role="paragraph" id="par_id3154855" xml-lang="en-US">In the data transfer of a selected entry from a list box or a combo box, both the list of the values displayed in the form, which was entered on the <link href="text/shared/02/01170101.xhp"><emph>General</emph></link> tab under <emph>List entries</emph>, and the value list entered on the <emph>Data</emph> tab under <emph>List content</emph>, are taken into consideration: If a (non-empty) text is at the selected position in the value list (<OPTION VALUE=...>), it will be transmitted. Otherwise, the text displayed in the (<OPTION>) control is sent.</paragraph> <paragraph role="paragraph" id="par_id3163377" xml-lang="en-US">If the value list is to contain an empty string, enter the value "$$$empty$$$" under <emph>List content</emph> at the corresponding position (note uppercase/lowercase). $[officename] interprets this input as an empty string and assigns it to the respective list entry.</paragraph> <paragraph role="paragraph" id="par_id3156309" xml-lang="en-US">The following table shows the connections between HTML, JavaScript, and the $[officename] field <emph>List content</emph> using an example list box named "ListBox1". In this case, "Item" designates a list entry visible in the form:</paragraph> <table id="tbl_id3145656"> |