Hey Mr C,
Thanks so much for responding, I must have missed it....
OK short version -- I want to create a theater view to show only
specific [subgenres] from genres -- drilling down from [genre] to [subgenre] to Artist to album
would like to create New Field(s) which auto-populate using only certain Genres (GroupSummary(...) ?)
I have 15 genres and 147 subgenres - call the new field [Category] (or maybe there would be 15 new fields?) e.g. If genre=Jazz; fill in only HardBop, Post-Bop, Swing If Pop/Rock fill in only A,B,C,D,E,F etc
long and convoluted, probably incomprehensible, explanation ...
Thinking about what you said I guess I should clarify, I have not made a mistake in tagging I have done it on purposes!
I use for Music: Category [grouping] >Genres [genre] > Styles [style] in theory
So a reduced Linnaean (
) Taxonomy e.g. would be Vertebrates, Mammals, Primates, =>Orangutans, etc
But to be practical I prefer putting Bats as Mammals
and Birds; and Flying Fish as Fish
and Birds because if I want to see all the Birds - Bats and Fish will come up BUT when I want to see all the Mammals I want to see Bats
not Flying Fish and if I look up Fish I want to see Flying Fish
not Bats.
Allmusic Guide does this all the time - e.g. BB King: R&B and Blues various styles belonging to both genres Prince: they him in 3 genres: R&B and Pop/Rock and Electronic
So MC handles this beautifully in one direction by creating for example secondary fields -- I have the standard Genre field + I created "Genres" as a calculated data field with this expression
[genre]&datatype= -- these two auto populate in both direction which is great for tagging -- I have also done this for the field Grouping/Group ...
BUT what actually is written to both fields (i.e. genre and genres) looks like this (separated by semi-colons ==>
a) Blues (Grouping) | Acoustic Blues (genre) --- no problem
b) Blues | Acoustic Blues; Delta Blues -- no problem
c) Blues; Country | Acoustic Blues; Alt. County -- problem
d) Jazz | Jazz-Funk; Contemporary Jazz; Hip-Hop -- problem
Ok so a and b are easy. These artists or albums are tagged with genres "taxonomically" correct
c) is how I like to tag when necessary -- alternative country, for the theater view, I would want to see only under Country with Acoustic Blues under Blues now they are showing up under both (understandable) --- this is the most important to me to resolve
d) I put this down to illustrate what would happen if I retagged putting artists in what I perceive would be there "dominant" category -- I would also like it shown under R&B=>Hip-Hop
I only see 3 solutions other than never attributing one genre per album or artist
1) Create another field like a Phylum
-- and manually populate this would be a real pain for ripping and tagging -- if this could be auto-populated by an expression however this would be the best IMO, but not sure how this can work
2) To figure out a type of rule/modifierer that would parse multiple genre-populated fields into a list that would be concatenated (euh not sure of the right word here) like Album - Year some how and use that for a view
3) Create a sort of Boolean expression which would show subgenres filtering out specific genres without NOT showing music tagged with multiple genres (of course I have no clue how to do this
OR remove [subgenre]from the drill down in my Theater View and go directly from a genre to all the artists then to the albums of each -- really not an option for me, too much music ...
Like Bonnie Raitt is in Pop/Rock and Country and Blues (depending on the album) - imagine Album X with a tag like Acoustic Blues; Country-Rock; Folk-Rock -- Click country, see only Country-Rock, see Artists which include Bonnie Raitt. Click Pop/Rock, see only Folk-Rock, click that and see artists including Bonnie Raitt Click country etc; etc.
Any input would really be appreciated ... thanks to anyone who even tried to read this