Re: [libreoffice-users] Re: Multiple select field in Base forms

On Fri, 2012-01-13 at 12:58 +0100, Alex Thurgood wrote:
> Le 13/01/2012 06:15, Marni Wilson a écrit :
>
> Hi Marni,
>
> > I am new to LibreOffice, and downloaded it initially for Base.  The main purpose for my 
> > database search is to create a music library, with details such as vocal parts, church season, 
> > instruments, etc.  Some of these would be best suited as a multiple select option in the form, 
> > but I seem to be having difficulty creating that.  Am I missing something?  This is my third 
> > attempt to find a database program that will give me this option...is it possible in Base?
>
> Try looking here :
>
> http://www.oooforum.org/forum/viewtopic.phtml?t=21159
>
> http://www.oooforum.org/forum/viewtopic.phtml?t=27761
>
> http://www.oooforum.org/forum/viewtopic.phtml?t=126402
>
> http://www.oooforum.org/forum/viewtopic.phtml?t=37079
>
> http://www.factooorpro.net/viewtopic.php?f=9&t=4909
>
> http://user.services.openoffice.org/fr/forum/viewtopic.php?f=3&t=29806
>
> http://user.services.openoffice.org/fr/forum/viewtopic.php?f=9&t=27622&hilit=s%C3%A9lection+multiple
>
>
> Basically, from what I understand of the above threads, if you want to 
> bind the multiple values selected to a database field, then this is not 
> possible with the current multiple selection control property.
>
> A multiple selection is only available for a free standing form control 
> list, i.e. one in which the data is presented or displayed in a Writer 
> form or Calc sheet, but can not be bound to a database field, unless you 
> store the values individually in a corresponding table (n-m 
> relationship). Alternatively, it is also apparently possible to do this 
> using a macro to write the data from the multiple selection into 
> corresponding fields in a bound table.
>
> As far as I know, Base does not currently support writing to ENUM or SET 
> data types, and most likely the control properties do not provide for 
> that within the current UNO API (although I haven't checked).
>
>
> Alex

     As another poster, I would like to know: What the form is suppose
to look like. What tables, queries of views will be used? What is meant
by multiple selections? Designing the parts of a DBMS requires knowing
the details.

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