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: [email protected]
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
