diff options
author | Gabor Kelemen <kelemeng@gnome.hu> | 2019-07-02 01:05:50 +0200 |
---|---|---|
committer | Gabor Kelemen <kelemen.gabor2@nisz.hu> | 2019-07-02 09:28:25 +0200 |
commit | 4b523164742b4eaffb576c0b1f507cf42f236ad5 (patch) | |
tree | 920fd0e9004bc02dfa145dc6a36c9eeb14cf060e | |
parent | 1bd7d25c1064639add894fb4ca49b217d389b8c6 (diff) |
Fix ahelp HIDs in form control Data pages
Change-Id: Iec13edc72bc5b1dbc83f73be142662917a6505cf
Reviewed-on: https://gerrit.libreoffice.org/74982
Tested-by: Jenkins
Reviewed-by: Gabor Kelemen <kelemen.gabor2@nisz.hu>
-rw-r--r-- | source/text/shared/02/01170102.xhp | 20 | ||||
-rw-r--r-- | source/text/shared/02/01170203.xhp | 29 |
2 files changed, 25 insertions, 24 deletions
diff --git a/source/text/shared/02/01170102.xhp b/source/text/shared/02/01170102.xhp index 65664d9f0e..350ef10933 100644 --- a/source/text/shared/02/01170102.xhp +++ b/source/text/shared/02/01170102.xhp @@ -51,7 +51,7 @@ <section id="Section23"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_REFVALUE" id="bm_id3147327" localize="false"/> <paragraph role="heading" id="hd_id3159121" xml-lang="en-US" level="2">Reference value (on)<comment>UFI: moved section from 01170101, changed name</comment></paragraph> - <paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"><ahelp hid="HID_PROP_REFVALUE" visibility="hidden">You can enter a reference value for the web form, which will be remitted to a server when sending the form. With database forms, the value entered is written in the database field, assigned to the control field.</ahelp> You can assign a reference value to option buttons and check boxes. The reference value will be remitted to a server when sending the web form. With database forms the value entered here will be written in the database assigned to the control field.</paragraph> + <paragraph role="paragraph" id="par_id3163812" xml-lang="en-US"><ahelp hid="." visibility="hidden">You can enter a reference value for the web form, which will be remitted to a server when sending the form. With database forms, the value entered is written in the database field, assigned to the control field.</ahelp> You can assign a reference value to option buttons and check boxes. The reference value will be remitted to a server when sending the web form. With database forms the value entered here will be written in the database assigned to the control field.</paragraph> <paragraph role="paragraph" id="par_id3150225" xml-lang="en-US"><emph>Reference values for web forms</emph></paragraph> <paragraph role="paragraph" id="par_id3147611" xml-lang="en-US">Reference values are useful if you design a web form and the information on the status of the control is to be transmitted to a server. If the control is clicked by the user, the corresponding reference value is sent to the server.</paragraph> <paragraph role="paragraph" id="par_id3149570" xml-lang="en-US">For example, if you have two control fields for the options "feminine" and "masculine", and assign a reference value of 1 to the field "feminine" and the value 2 to the "masculine" field, the value 1 is transmitted to the server if a user clicks the "feminine" field and value 2 is sent if the "masculine" field is clicked.</paragraph> @@ -61,7 +61,7 @@ <section id="Section1"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CONTROLSOURCE" id="bm_id3157976" localize="false"/> <paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2">Data field</paragraph> - <paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"><ahelp hid="HID_PROP_CONTROLSOURCE" visibility="hidden">Specifies the field of the data source table to which the control refers.</ahelp> With database forms, you can link controls with the data fields.</paragraph> + <paragraph role="paragraph" id="par_id3155852" xml-lang="en-US"><ahelp hid="." visibility="hidden">Specifies the field of the data source table to which the control refers.</ahelp> With database forms, you can link controls with the data fields.</paragraph> <paragraph role="paragraph" id="par_id3153224" xml-lang="en-US">You have several possibilities:</paragraph> <list type="ordered"> <listitem> @@ -97,7 +97,7 @@ <section id="Section2"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUNDCOLUMN" id="bm_id3150297" localize="false"/> <paragraph role="heading" id="hd_id3154664" xml-lang="en-US" level="2">Bound field</paragraph> - <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><ahelp hid="HID_PROP_BOUNDCOLUMN" visibility="hidden">Use an index to specify the table field or table SQL query to link to the field that is provided under <emph>Data field</emph>. Valid values for this property are 1, 2, 3, and so on.</ahelp><comment>UFI: issue #i32749#</comment></paragraph> + <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US"><ahelp hid="." visibility="hidden">Use an index to specify the table field or table SQL query to link to the field that is provided under <emph>Data field</emph>. Valid values for this property are 1, 2, 3, and so on.</ahelp><comment>UFI: issue #i32749#</comment></paragraph> <paragraph role="note" id="par_idN10AD2" xml-lang="en-US">If you delete the contents of the <emph>Bound field</emph> cell in the property browser, the first field of the result set is used to display and to exchange data.<comment>UFI: issue #i32749#</comment></paragraph> <paragraph role="paragraph" id="par_id3154588" xml-lang="en-US">This property for list boxes defines which data field of a linked table is displayed in the form.</paragraph> <paragraph role="paragraph" id="par_id3151213" xml-lang="en-US">If a list box in the form is to display contents of a table linked to the form table, then define in the <emph>Type of list contents</emph> field if the display is determined by an SQL command or the (linked) table is accessed. With the <emph>Bound field</emph> property, you use an index to specify to which data field of the query or of the table the list field is linked.</paragraph> @@ -184,14 +184,14 @@ <section id="Section3"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCETYPE" id="bm_id3153316" localize="false"/> <paragraph role="heading" id="hd_id3149772" xml-lang="en-US" level="2">Type of list contents</paragraph> - <paragraph role="paragraph" id="par_id3154419" xml-lang="en-US"><ahelp hid="HID_PROP_LISTSOURCETYPE" 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_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_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"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LISTSOURCE" id="bm_id3148839" localize="false"/> <paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2">List content</paragraph> - <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"><ahelp hid="HID_PROP_LISTSOURCE">With database forms, specifies the data source for the list content of the form-element. This field can be used to define a value list for documents without a database connection.</ahelp></paragraph> + <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US"><ahelp hid=".">With database forms, specifies the data source for the list content of the form-element. This field can be used to define a value list for documents without a database connection.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3168456" xml-lang="en-US">In the case of database forms, the data source determines the entries of the list or combo box. Depending on the selected type, you have a choice between different data sources under <emph>List content</emph>, provided that these objects exist in your database. All available database objects of the type selected under <emph>Type of list contents</emph> are offered here. If you have selected the "Value List" option as the type, you can use references for database forms. If the display of the control is controlled by an SQL command, the SQL statement is entered here.</paragraph> <paragraph role="paragraph" id="par_id3155870" xml-lang="en-US">Examples of SQL statements:</paragraph> <paragraph role="paragraph" id="par_id3144504" xml-lang="en-US">For list boxes, an SQL statement may have the following form:</paragraph> @@ -267,19 +267,19 @@ <section id="Section5"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_EMPTY_IS_NULL" id="bm_id3150628" localize="false"/> <paragraph role="heading" id="hd_id3148901" xml-lang="en-US" level="2">Empty string is NULL</paragraph> - <paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"><ahelp hid="HID_PROP_EMPTY_IS_NULL">Defines how an empty string input should be handled. If set to "Yes", an input string of length zero will be treated as a value NULL. If set to "No", any input will be treated as-is without any conversion.</ahelp></paragraph> + <paragraph role="paragraph" id="par_id3145357" xml-lang="en-US"><ahelp hid=".">Defines how an empty string input should be handled. If set to "Yes", an input string of length zero will be treated as a value NULL. If set to "No", any input will be treated as-is without any conversion.</ahelp></paragraph> <paragraph role="paragraph" id="par_id0820200812403467" xml-lang="en-US">An empty string is a string of length zero (<emph>""</emph>). Normally, a value NULL is not the same as an empty string. In general, a term NULL is used to denote an undefined value, an unknown value, or "no value has been entered yet."</paragraph> <paragraph role="paragraph" id="par_id0820200812403455" xml-lang="en-US">Database systems vary and they might handle a value NULL differently. Refer to documentations of the database that you are using.</paragraph> </section> <section id="Section6"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTERPROPOSAL" id="bm_id3149393" localize="false"/> <paragraph role="heading" id="hd_id3161653" xml-lang="en-US" level="2">Filter proposal</paragraph> - <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><variable id="filtervorschlag"><ahelp hid="HID_PROP_FILTERPROPOSAL">While designing your form, you can set the "Filter proposal" property for each text box in the <emph>Data</emph> tab of the corresponding <emph>Properties</emph> dialog. In subsequent searches in the filter mode, you can select from all information contained in these fields.</ahelp> The field content can then be selected using the <emph>AutoComplete</emph> function. Note, however, that this function requires a greater amount of memory space and time, especially when used in large databases and should therefore be used sparingly.</variable></paragraph> + <paragraph role="paragraph" id="par_id3151221" xml-lang="en-US"><variable id="filtervorschlag"><ahelp hid=".">While designing your form, you can set the "Filter proposal" property for each text box in the <emph>Data</emph> tab of the corresponding <emph>Properties</emph> dialog. In subsequent searches in the filter mode, you can select from all information contained in these fields.</ahelp> The field content can then be selected using the <emph>AutoComplete</emph> function. Note, however, that this function requires a greater amount of memory space and time, especially when used in large databases and should therefore be used sparingly.</variable></paragraph> </section> <section id="Section9"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_BOUND_CELL" id="bm_id4214300" localize="false"/> <paragraph role="heading" id="par_idN10EE3" xml-lang="en-US" level="2">Linked cell</paragraph> - <paragraph role="paragraph" id="par_idN10EE7" xml-lang="en-US"><ahelp hid="HID_PROP_BOUND_CELL">Specifies the reference to a linked cell on a spreadsheet. The live state or contents of the control are linked to the cell contents.</ahelp> The following tables list the controls and their corresponding link type:</paragraph> + <paragraph role="paragraph" id="par_idN10EE7" xml-lang="en-US"><ahelp hid=".">Specifies the reference to a linked cell on a spreadsheet. The live state or contents of the control are linked to the cell contents.</ahelp> The following tables list the controls and their corresponding link type:</paragraph> <paragraph role="heading" id="par_idN10EF7" xml-lang="en-US" level="3">Check box with linked cell</paragraph> <table id="tbl_id4947965"> <tablerow> @@ -674,7 +674,7 @@ <section id="Section8"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CELL_EXCHANGE_TYPE" id="bm_id5563219" localize="false"/> <paragraph role="heading" id="par_idN11163" xml-lang="en-US" level="2">Contents of the linked cell</paragraph> - <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp hid="HID_PROP_CELL_EXCHANGE_TYPE">Select the mode of linking a list box with a linked cell on a spreadsheet.</ahelp></paragraph> + <paragraph role="paragraph" id="par_idN11167" xml-lang="en-US"><ahelp hid=".">Select the mode of linking a list box with a linked cell on a spreadsheet.</ahelp></paragraph> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_idN11179" xml-lang="en-US"><emph>Linked contents:</emph> Synchronize the text contents of the selected list box entry with the cell contents. Select "The selected entry".</paragraph> @@ -687,7 +687,7 @@ <section id="Section7"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_LIST_CELL_RANGE" id="bm_id9886165" localize="false"/> <paragraph role="heading" id="par_idN1118B" xml-lang="en-US" level="2">Source cell range<comment>UFI: in the spec, this is "Source range of the list". Named it as seen in 680m38</comment></paragraph> - <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><ahelp hid="HID_PROP_LIST_CELL_RANGE">Enter a cell range that contains the entries for a list box or combo box on a spreadsheet.</ahelp> If you enter a multi-column range, only the contents of the leftmost column are used to fill the control.</paragraph> + <paragraph role="paragraph" id="par_idN111A1" xml-lang="en-US"><ahelp hid=".">Enter a cell range that contains the entries for a list box or combo box on a spreadsheet.</ahelp> If you enter a multi-column range, only the contents of the leftmost column are used to fill the control.</paragraph> </section> </sort> </body> diff --git a/source/text/shared/02/01170203.xhp b/source/text/shared/02/01170203.xhp index 8415984054..0edbfd2c70 100644 --- a/source/text/shared/02/01170203.xhp +++ b/source/text/shared/02/01170203.xhp @@ -45,11 +45,11 @@ <sort> <section id="Section1"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATASOURCE" id="bm_id3153146" localize="false"/><paragraph role="heading" id="hd_id3154810" xml-lang="en-US" level="2">Data source<comment>UFI: was Database</comment></paragraph> -<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US"><ahelp hid="HID_PROP_DATASOURCE">Defines the data source to which the form should refer.</ahelp> If you click the <emph>...</emph> button, you call the <link href="text/shared/01/01020000.xhp" name="Open"><emph>Open</emph></link> dialog, where you can choose a data source.</paragraph> +<paragraph role="paragraph" id="par_id3152349" xml-lang="en-US"><ahelp hid=".">Defines the data source to which the form should refer.</ahelp> If you click the <emph>...</emph> button, you call the <link href="text/shared/01/01020000.xhp" name="Open"><emph>Open</emph></link> dialog, where you can choose a data source.</paragraph> </section> <section id="Section2"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CURSORSOURCE" id="bm_id3150275" localize="false"/><paragraph role="heading" id="hd_id3146948" xml-lang="en-US" level="2">Content<comment>UFI: was Data source</comment></paragraph> -<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp hid="HID_PROP_CURSORSOURCE">Determines the content to be used for the form. The content can be an existing table or a query (previously created in the database), or it can be defined by an SQL-statement. Before you enter a content you have to define the exact type in <emph>Content type</emph>.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp hid=".">Determines the content to be used for the form. The content can be an existing table or a query (previously created in the database), or it can be defined by an SQL-statement. Before you enter a content you have to define the exact type in <emph>Content type</emph>.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3149657" xml-lang="en-US">If you have selected either "Table" or "Query" in <emph>Content type</emph>, the box lists all the tables and queries set up in the selected database.</paragraph> </section> <section id="Section3"> @@ -59,31 +59,32 @@ </section> <section id="Section4"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ESCAPE_PROCESSING" id="bm_id3144433" localize="false"/><paragraph role="heading" id="hd_id3158409" xml-lang="en-US" level="2">Analyze SQL command</paragraph> -<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp hid="HID_PROP_ESCAPE_PROCESSING">Specifies whether the SQL statement is to be analyzed by %PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button next to the <emph>Content</emph> list box. This will open a window where you can graphically create a database query. When you close that window, the SQL statement for the created query will be inserted in the <emph>Content</emph> list box.</paragraph> +<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp hid=".">Specifies whether the SQL statement is to be analyzed by %PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button next to the <emph>Content</emph> list box. This will open a window where you can graphically create a database query. When you close that window, the SQL statement for the created query will be inserted in the <emph>Content</emph> list box.</paragraph> </section> <section id="Section5"> -<!-- removed HID HID_PROP_FILTER_CRITERIA --><paragraph role="heading" id="hd_id3154684" xml-lang="en-US" level="2">Filter</paragraph> -<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp hid="HID_PROP_FILTER_CRITERIA">Enter the required conditions for filtering the data in the form. The filter specifications follow SQL rules without using the WHERE clause.</ahelp> For example, if you want to display all records with the "Mike" forename, type into the data field: Forename = 'Mike'. You can also combine conditions: Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these two conditions will be displayed.</paragraph> +<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_FILTER" id="bm_id3144434" localize="false"/> +<paragraph role="heading" id="hd_id3154684" xml-lang="en-US" level="2">Filter</paragraph> +<paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp hid=".">Enter the required conditions for filtering the data in the form. The filter specifications follow SQL rules without using the WHERE clause.</ahelp> For example, if you want to display all records with the "Mike" forename, type into the data field: Forename = 'Mike'. You can also combine conditions: Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these two conditions will be displayed.</paragraph> <paragraph role="paragraph" id="par_id3156212" xml-lang="en-US">The filter function is available in user mode through the <link href="text/shared/02/12030000.xhp" name="AutoFilter"><emph>AutoFilter</emph></link> and <link href="text/shared/02/12090000.xhp" name="Default Filter"><emph>Default Filter</emph></link> icons on the <link href="text/shared/main0213.xhp" name="Form Navigation Bar"><emph>Form Navigation</emph> Bar</link>.</paragraph> </section> <section id="Section6"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SORT_CRITERIA" id="bm_id3151353" localize="false"/><paragraph role="heading" id="hd_id3156005" xml-lang="en-US" level="2">Sort</paragraph> -<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp hid="HID_PROP_SORT_CRITERIA">Specifies the conditions to sort the data in the form. The specification of the sorting conditions follows SQL rules without the use of the ORDER BY clause.</ahelp> For example, if you want all records of a database to be sorted in one field in an ascending order and in another field in a descending order, enter Forename ASC, Name DESC (presuming Forename and Name are the names of the data fields).</paragraph> +<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp hid=".">Specifies the conditions to sort the data in the form. The specification of the sorting conditions follows SQL rules without the use of the ORDER BY clause.</ahelp> For example, if you want all records of a database to be sorted in one field in an ascending order and in another field in a descending order, enter Forename ASC, Name DESC (presuming Forename and Name are the names of the data fields).</paragraph> <paragraph role="paragraph" id="par_id3156444" xml-lang="en-US">The appropriate icons on the <link href="text/shared/main0213.xhp" name="Form Navigation Bar"><emph>Form Navigation</emph> Bar</link> can be used in User mode to sort: <link href="text/shared/02/12010000.xhp" name="Sort Ascending"><emph>Sort Ascending</emph></link>, <link href="text/shared/02/12020000.xhp" name="Sort Descending"><emph>Sort Descending</emph></link>, <link href="text/shared/02/12100100.xhp" name="Sort"><emph>Sort</emph></link>.</paragraph> </section> <section id="Section7"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_DATAENTRY" id="bm_id3154129" localize="false"/><paragraph role="heading" id="hd_id3148616" xml-lang="en-US" level="2">Add data only</paragraph> -<paragraph role="paragraph" id="par_id3153139" xml-lang="en-US"><ahelp hid="HID_PROP_DATAENTRY">Determines if the form only allows the addition of new data (Yes) or if it allows other properties as well (No).</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153139" xml-lang="en-US"><ahelp hid=".">Determines if the form only allows the addition of new data (Yes) or if it allows other properties as well (No).</ahelp></paragraph> <paragraph role="note" id="par_id3148575" xml-lang="en-US">If <emph>Add data only</emph> is set to "Yes", changing or deleting data is not possible.</paragraph> </section> <section id="Section8"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_NAVIGATION" id="bm_id3155418" localize="false"/><paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2">Navigation bar</paragraph> -<paragraph role="paragraph" id="par_id3157976" xml-lang="en-US"><ahelp hid="HID_PROP_NAVIGATION">Specifies whether the navigation functions in the lower form bar can be used.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3157976" xml-lang="en-US"><ahelp hid=".">Specifies whether the navigation functions in the lower form bar can be used.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3149485" xml-lang="en-US">The "Parent Form" option is used for subforms. If you choose this option for a subform, you can navigate using the records of the main form if the cursor is placed in the subform. A subform is linked to the parent form by a 1:1 relationship, so navigation is always performed in the parent form.</paragraph> </section> <section id="Section9"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_CYCLE" id="bm_id3151282" localize="false"/><paragraph role="heading" id="hd_id3151051" xml-lang="en-US" level="2">Cycle</paragraph> -<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp hid="HID_PROP_CYCLE">Determines how the navigation should be done using the tab key.</ahelp> Using the tab key, you can move forward in the form. If you simultaneously press the Shift key, the navigation will follow the opposite direction. If you reach the last (or the first) field and press the tab key again, it can have various effects. Define the key control with the following options:</paragraph> +<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp hid=".">Determines how the navigation should be done using the tab key.</ahelp> Using the tab key, you can move forward in the form. If you simultaneously press the Shift key, the navigation will follow the opposite direction. If you reach the last (or the first) field and press the tab key again, it can have various effects. Define the key control with the following options:</paragraph> <table id="tbl_id3150658"> <tablerow> <tablecell colspan="" rowspan=""> @@ -129,19 +130,19 @@ </section> <section id="Section10"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_ADDITIONS" id="bm_id3155445" localize="false"/><paragraph role="heading" id="hd_id3155064" xml-lang="en-US" level="2">Allow additions</paragraph> -<paragraph role="paragraph" id="par_id3154360" xml-lang="en-US"><ahelp hid="HID_PROP_ALLOW_ADDITIONS">Determines if data can be added.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154360" xml-lang="en-US"><ahelp hid=".">Determines if data can be added.</ahelp></paragraph> </section> <section id="Section11"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_EDITS" id="bm_id3083286" localize="false"/><paragraph role="heading" id="hd_id3156054" xml-lang="en-US" level="2">Allow modifications</paragraph> -<paragraph role="paragraph" id="par_id3156377" xml-lang="en-US"><ahelp hid="HID_PROP_ALLOW_EDITS"> Determines if the data can be modified.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3156377" xml-lang="en-US"><ahelp hid="."> Determines if the data can be modified.</ahelp></paragraph> </section> <section id="Section12"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_ALLOW_DELETIONS" id="bm_id3153924" localize="false"/><paragraph role="heading" id="hd_id3149019" xml-lang="en-US" level="2">Allow deletions</paragraph> -<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US"><ahelp hid="HID_PROP_ALLOW_DELETIONS">Determines if the data can be deleted.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US"><ahelp hid=".">Determines if the data can be deleted.</ahelp></paragraph> </section> <section id="Section13"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_MASTERFIELDS" id="bm_id3147097" localize="false"/><paragraph role="heading" id="hd_id3153714" xml-lang="en-US" level="2">Link master fields</paragraph> -<paragraph role="paragraph" id="par_id3147339" xml-lang="en-US"><ahelp hid="HID_PROP_MASTERFIELDS">If you create a <link href="text/shared/02/01170203.xhp" name="subform">subform</link>, enter the data field of the parent form responsible for the synchronization between parent and subform.</ahelp> To enter multiple values, press Shift + Enter after each input line.<comment>UFI: fixes #i22439#</comment></paragraph> +<paragraph role="paragraph" id="par_id3147339" xml-lang="en-US"><ahelp hid=".">If you create a <link href="text/shared/02/01170203.xhp" name="subform">subform</link>, enter the data field of the parent form responsible for the synchronization between parent and subform.</ahelp> To enter multiple values, press Shift + Enter after each input line.<comment>UFI: fixes #i22439#</comment></paragraph> <paragraph role="paragraph" id="par_id3149568" xml-lang="en-US">The subform is based on an <link href="text/shared/00/00000005.xhp#sql" name="SQL">SQL</link> query; more specifically, on a <link href="text/shared/explorer/database/02010100.xhp" name="Parameter Query">Parameter Query</link>. If a field name is entered in the <emph>Link master fields</emph> box, the data contained in that field in the main form is read to a variable that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL statement, this variable is compared to the table data that the subform refers to. Alternatively, you can enter the column name in the <emph>Link master fields</emph> box.</paragraph> <paragraph role="paragraph" id="par_id3156089" xml-lang="en-US">Consider the following example:</paragraph> <paragraph role="paragraph" id="par_id3151017" xml-lang="en-US">The database table on which the form is based is, for example, a customer database ("Customer"), where every customer has been given a unique number in a data field named "Cust_ID". A customer's orders are maintained in another database table. You now want to see each customer's orders after entering them into the form. In order to do this you should create a subform. Under <emph>Link master fields</emph> enter the data field from the customer database which clearly identifies the customer, that is, Cust_ID. Under <emph>Link slave fields</emph> enter the name of a variable which is to accept the data of the field Cust_ID, for example, x.</paragraph> @@ -154,7 +155,7 @@ </section> <section id="Section14"> <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_SLAVEFIELDS" id="bm_id3145789" localize="false"/><paragraph role="heading" id="hd_id3150648" xml-lang="en-US" level="2">Link slave fields</paragraph> -<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp hid="HID_PROP_SLAVEFIELDS">If you create a subform, enter the variable where possible values from the parent form field can be stored.</ahelp> If a subform is based on a query, enter the variable that you defined in the query. If you create a form using an SQL statement entered in the <emph>Data source</emph> field, enter the variable you used in the statement. You can choose any variable name. If you want to enter multiple values, press Shift + Enter.</paragraph> +<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp hid=".">If you create a subform, enter the variable where possible values from the parent form field can be stored.</ahelp> If a subform is based on a query, enter the variable that you defined in the query. If you create a form using an SQL statement entered in the <emph>Data source</emph> field, enter the variable you used in the statement. You can choose any variable name. If you want to enter multiple values, press Shift + Enter.</paragraph> <paragraph role="paragraph" id="par_id3155114" xml-lang="en-US">If, for example, you specified the Customer_ID database field as a parent field under <emph>Link master fields</emph>, then you can define under <emph>Link slave fields</emph> the name of the variable in which the values of the Customer_ID database field are to be stored. If you now specify an SQL statement in the <emph>Data source</emph> box using this variable, the relevant values are displayed in the subform.</paragraph> </section> </sort> |