Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Alexander Thurgood wrote:
Le 12/06/12 21:08, Dan a écrit :

Hi Dan,

      To populate a list or combo box, I have been using single field
tables. Seems like it should be possible to use a single table for more
than one list or combo box. (The SQL statement for selecting a field for
I'm not sure I understand you correctly :

- do you want Table1.field1 and Table1.field2 to populate respectively
two separate list/combo boxes in your form ?

- or Table1.field1 to populate two separate list/combo boxes,
potentially displaying 2 different values (one for each combo/list box)
from the possible list of entries ?

Your right, I was talking about two different tables and was not clear at all. What I do now: for list boxes I create single field tables (the field is the primary key and uses VARCHAR as the field type. I have a database I use for my budget that contains three similar tables for three list boxes. (Budget level 1, Budget level 2, and Budget level 3) What I was thinking was to create one table (call it Budget) for the three list boxes containing three data fields: Budget 1, Budget 2, and Budget 3. With this I would create a fourth field (ID) as the primary key with AutoValue set to Yes. Budget 1 is for Budget level 1, etc. Probably, the SQL mentioned by Andreas may be all that is necessary with this structure. If so, would this also mean that values shown in the list Box for Budget level 1 will also appear in reports containing Budget level 1. (In the past in a form I have had Budget level 1 values coming from Budget 1 of the Budget table while in a report, the Budget level 1 values came from ID. I was probably not using SQL for this then.) Is there a particular order for the fields of the Budget table? Perhaps ID should be the first field followed by Budget 1, Budget 2, Budget 3?


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.