 | |
#1
 
| |||
| |||
|
score order -
11-16-2006
, 07:39 PM
#2
| |||
| |||
|
|
I have FmPro 8. I am compiling a database of woodwind music and would like to sort it by instrument, in score order. I.e. flute, oboe, clarinet, bassoon, alto saxophone, tenor saxophone. I have not managed to work out how to set it to sort in this particular order, rather than alphabetically. Help, please!! Regards Eileen |
#3
| |||
| |||
|
|
Create a value-list and set the sort order to that. TK Eileen wrote: I have FmPro 8. I am compiling a database of woodwind music and would like to sort it by instrument, in score order. I.e. flute, oboe, clarinet, bassoon, alto saxophone, tenor saxophone. I have not managed to work out how to set it to sort in this particular order, rather than alphabetically. Help, please!! Regards Eileen The solution above will work just fine. Another solution with a bit more |
Create a new table, called "Score Order" with two fields - a text field for
the instrument name, and a number field that contains a value from 1 to
however many instruments you have. Populate this table with a record for
each instrument, and assign the numbers in the order you want the
instruments to sort.
Create a relationship between the instrument field in the main table and the
instrument field in the Score Order table. In your listings sort by the
related number field instead of the instrument name.
It's helpful if you make the instrument field on your data entry forms a
pop-up that uses a value list based on the names in the Score Order table.
That will ensure that you always spell them identically.
The reason this more complicated solution might be attractive is for full
orchestra databases and music library databases where it was also needed to
sort and group by orchestra sections like strings, woodwinds, brass,
percussion, etc. For that I would add a third field to the Score Order
table that has the same number for each member of the group. For example
violins, viola, cello and bass would all be #1 (strings); flute, oboe,
clarinet, bassoon, .... would be #2 (woodwinds), etc. I would sort first by
section order, then by score order to get things straight.
hth
Don
#4
| |||
| |||
|
|
"TKnTexas" <tkntexas55 (AT) aol (DOT) com> wrote in message news:1163730144.675644.10030 (AT) m7g2000cwm (DOT) googlegroups.com... Create a value-list and set the sort order to that. TK Eileen wrote: I have FmPro 8. I am compiling a database of woodwind music and would like to sort it by instrument, in score order. I.e. flute, oboe, clarinet, bassoon, alto saxophone, tenor saxophone. I have not managed to work out how to set it to sort in this particular order, rather than alphabetically. Help, please!! Regards Eileen The solution above will work just fine. Another solution with a bit more detail in case it's helpful: Create a new table, called "Score Order" with two fields - a text field for the instrument name, and a number field that contains a value from 1 to however many instruments you have. Populate this table with a record for each instrument, and assign the numbers in the order you want the instruments to sort. Create a relationship between the instrument field in the main table and the instrument field in the Score Order table. In your listings sort by the related number field instead of the instrument name. It's helpful if you make the instrument field on your data entry forms a pop-up that uses a value list based on the names in the Score Order table. That will ensure that you always spell them identically. The reason this more complicated solution might be attractive is for full orchestra databases and music library databases where it was also needed to sort and group by orchestra sections like strings, woodwinds, brass, percussion, etc. For that I would add a third field to the Score Order table that has the same number for each member of the group. For example violins, viola, cello and bass would all be #1 (strings); flute, oboe, clarinet, bassoon, .... would be #2 (woodwinds), etc. I would sort first by section order, then by score order to get things straight. hth Don |
#5
| |||
| |||
|
|
Thanks to you both. I'm going to experiment with these. Regards Eileen "Don" <reply.to.group (AT) saynotospam (DOT) com> wrote in message news:eLednUxYnZwc58PYnZ2dnUVZ_qCdnZ2d (AT) comcast (DOT) com... "TKnTexas" <tkntexas55 (AT) aol (DOT) com> wrote in message news:1163730144.675644.10030 (AT) m7g2000cwm (DOT) googlegroups.com... Create a value-list and set the sort order to that. TK Eileen wrote: I have FmPro 8. I am compiling a database of woodwind music and would like to sort it by instrument, in score order. I.e. flute, oboe, clarinet, bassoon, alto saxophone, tenor saxophone. I have not managed to work out how to set it to sort in this particular order, rather than alphabetically. Help, please!! Regards Eileen The solution above will work just fine. Another solution with a bit more detail in case it's helpful: Create a new table, called "Score Order" with two fields - a text field for the instrument name, and a number field that contains a value from 1 to however many instruments you have. Populate this table with a record for each instrument, and assign the numbers in the order you want the instruments to sort. Create a relationship between the instrument field in the main table and the instrument field in the Score Order table. In your listings sort by the related number field instead of the instrument name. It's helpful if you make the instrument field on your data entry forms a pop-up that uses a value list based on the names in the Score Order table. That will ensure that you always spell them identically. The reason this more complicated solution might be attractive is for full orchestra databases and music library databases where it was also needed to sort and group by orchestra sections like strings, woodwinds, brass, percussion, etc. For that I would add a third field to the Score Order table that has the same number for each member of the group. For example violins, viola, cello and bass would all be #1 (strings); flute, oboe, clarinet, bassoon, .... would be #2 (woodwinds), etc. I would sort first by section order, then by score order to get things straight. hth Don |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.