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