helpcontent2/source/text/shared/02/01170903.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: 01170903.xhp,v $
  15  * $Revision: 1.7 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textshared0201170903xml" indexer="include" status="PUBLISH">
  41 <title id="tit" xml-lang="en-US">List Box Wizard: Field Link</title>
  42 <filename>/text/shared/02/01170903.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46 <section id="seite3a">
  47 <paragraph role="heading" id="hd_id3149119" xml-lang="en-US" level="1" l10n="U" oldref="20"><link href="text/shared/02/01170903.xhp" name="List Box Wizard: Field Link">List Box Wizard: Field Link</link></paragraph>
  48 <paragraph role="paragraph" id="par_id3159224" xml-lang="en-US" l10n="U" oldref="15">Indicates through which fields tables of values and list tables are linked.</paragraph>
  49 </section>
  50 <paragraph role="paragraph" id="par_id3150499" xml-lang="en-US" l10n="U" oldref="27">The value table is the table of the current form where the list field is inserted. The list table is the table whose data is to be shown in the list field. Both tables must be linked over a mutual data field. These links are to be entered on this page of the wizard. The field names must not necessarily be the same (this depends upon how the field names are defined in both tables), but both fields must have the same field type.</paragraph>
  51 <section id="howtoget">
  52   <embed href="text/shared/00/00040501.xhp#aupikomli3a"/>
  53 </section>
  54 <bookmark xml-lang="en-US" branch="hid/DBP_COMBOBOX_RID_PAGE_LCW_FIELDLINK_CMB_VALUELISTFIELD" id="bm_id3153910" localize="false"/><paragraph role="heading" id="hd_id3149180" xml-lang="en-US" level="2" l10n="U" oldref="16">Value table field</paragraph>
  55 <paragraph role="paragraph" id="par_id3150789" xml-lang="en-US" l10n="U" oldref="17"><ahelp hid="DBP_COMBOBOX_RID_PAGE_LCW_FIELDLINK_CMB_VALUELISTFIELD">Specifies the current form data field which should be related to a field in the linked table.</ahelp> In addition, click the desired data field in the list field below.</paragraph>
  56 <paragraph role="paragraph" id="par_id3145669" xml-lang="en-US" l10n="U" oldref="25">In <link href="text/shared/02/01170102.xhp" name="Control - Properties">Control - Properties</link>, the specified field will appear as an entry in the <emph>Data</emph> tab page under <emph>Data field</emph>.</paragraph>
  57 <bookmark xml-lang="en-US" branch="hid/DBP_COMBOBOX_RID_PAGE_LCW_FIELDLINK_CMB_TABLEFIELD" id="bm_id3147009" localize="false"/><paragraph role="heading" id="hd_id3149827" xml-lang="en-US" level="2" l10n="U" oldref="18">List table field</paragraph>
  58 <paragraph role="paragraph" id="par_id3155391" xml-lang="en-US" l10n="U" oldref="19"><ahelp hid="DBP_COMBOBOX_RID_PAGE_LCW_FIELDLINK_CMB_TABLEFIELD">Specifies the linked table data field, which is related to the specified value table field.</ahelp> In addition, click the data field in the lower list field.</paragraph>
  59 <paragraph role="paragraph" id="par_id3154823" xml-lang="en-US" l10n="U" oldref="26">In <link href="text/shared/02/01170102.xhp" name="Control - Properties">Control - Properties</link>, the specified field will appear in the <emph>Data</emph> tab page of a SQL statement under <emph>List Contents</emph>.</paragraph>
  60 </body>
  61 </helpdocument>