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

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


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