Hi :) I think it helps to use an external back-end rather than the default internal one.
It sounds as though you need a few tiny tables that have a set relationship to the main table. One of the sub-tables would have just 2 columns; one for Id/key/reference-number and one that lists the option you mentioned (vocal parts, church season, instruments). Then in the main table one column would have a relationship of 1-to-many (err, i think that way around? or would it be 1-to-1?) with the key of that sub-table. On the other hand it might be easier to have a flat database (like a spreadsheet) rather than a relational one. There is some draft documentation appearing for Base http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide which might help. Just out of curiosity please could you let us know what other database programs you have tried? Did you manage to build-up a table of data in any of them? If so it might be good to get Base to use that table as it's back-end as that would solve 2 issues in one go. Regards from Tom :) --- On Fri, 13/1/12, Marni Wilson <[email protected]> wrote: From: Marni Wilson <[email protected]> Subject: [libreoffice-users] Multiple select field in Base forms To: [email protected] Date: Friday, 13 January, 2012, 5:15 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? Thank you for your help.... Marni -- 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 -- 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
