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
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
Then, to associate instruments with pieces of music you'd have an
instrumentLink table. It's fields are
id (instrumentlinkid) 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?
One small step for mankind...
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy