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

In general terms, Jay's given you the answer.

To be a little more specific, here's an outline.

You have a music table.
It has columns

id (some people would call it musicid), integer will probably be ok
title
composer
arranged
publisher
name of collection
file number (what's this?  Is it vital?)
Instrument notes (hmmm, probably, if this pertains only and 
necessarily to a specific piece of music)

You have an instrument table.  It fields

id (those same people would probably call it "instrumentid"), integer
instrument

Then, to associate instruments with pieces of music you'd have an 
instrumentLink table.  It's fields are

id (instrumentlinkid)   integer
musicid                 integer
instrumentid            integer


Then, when you want to know which instruments are required for a 
specific piece of music you ask

SELECT title, instrument FROM music
JOIN instrumentlink ON instrumentlink.musicid = music.id
JOIN instrument ON instrument.id = instrumentlink.instrumentid

And then similarly for seasons & occasions.
To come back to what I suspect was the actual thrust of your initial 
post, I think ("think" being very operative here) you can have a 
multi-select dropdown box, so you can scrap the (very untidy) "other" 
and "additional" boxes for instruments.  I "think" you can get LO to 
handle setting each relevant line in such a dropdown box when the 
links are already made.  I "think" you'll need to write a little bit 
of code to crete those links when you're setting up a piece of music.

Entirely resist the thought that some things are so fixed (seasons, 
for example) that you don't need a table and you can hard code them.  
Next thing you know you'll be up on a high place being shown all the 
peoples of the earth.

Does that do it?

Mark Stanton
One small step for mankind...



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