Re: [libreoffice-users] Re: List and Combo boxes

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 ?
>
>
> Alex
    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?

--Dan


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted