source/text/shared/02/01170901.xhp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

<?xml version="1.0" encoding="UTF-8"?>


<!--
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 -->

<helpdocument version="1.0">
<meta>
<topic id="textshared0201170901xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Combo Box / List Box Wizard: Table Selection</title>
<filename>/text/shared/02/01170901.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
</history>
</meta>
<body>
<section id="page1">
<bookmark xml-lang="en-US" branch="hid/modules/sabpilot/ui/contenttablepage/TableSelectionPage" id="bm_id3150808" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/sabpilot/ui/contenttablepage/@@nowidget@@" id="bm_id3150808" localize="false"/>
<paragraph role="heading" id="hd_id3154228" xml-lang="en-US" level="1"><link href="text/shared/02/01170901.xhp" name="Combo Box / List Box Wizard: Table Selection">Combo Box / List Box Wizard: Table Selection</link></paragraph>
<paragraph role="paragraph" id="par_id3149716" xml-lang="en-US">Specifies a table from the available database tables that contains the data field whose content should be displayed as a list entry.</paragraph>
</section>
<section id="howtoget">
  <embed href="text/shared/00/00040501.xhp#aupikomli1"/>
</section>
<paragraph role="paragraph" id="par_id3153114" xml-lang="en-US">For list boxes, a table that can be linked with the current form table is indicated. The link table must have at least one field in common with the table of the current form. This makes it possible to establish an unambiguous reference.</paragraph>
<paragraph role="paragraph" id="par_id3155555" xml-lang="en-US">For combo boxes, there must be a relationship between the form table and the table containing the data to be displayed in the combo box.</paragraph>
<paragraph role="heading" id="hd_id3147226" xml-lang="en-US" level="2">Table</paragraph>
<paragraph role="paragraph" id="par_id3155338" xml-lang="en-US"><ahelp hid="modules/sabpilot/ui/contenttablepage/table">In the<emph> Table </emph>field, select the table containing the data field whose content should be displayed in the control field.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3159233" xml-lang="en-US">The table given here appears in the <link href="text/shared/02/01170102.xhp" name="Control properties">Control properties</link> as an element of an SQL statement in the <emph>List Contents</emph> field.</paragraph>
</body>
</helpdocument>