If I understand you, this is what I do with my tracks, and I'm sure quite a few others
on this forum do as well, since that's where I learned how to.
I've tried several different field names, now I just have three additional fields (lists),
[Artists Featured] - the obvious, plus I use for soundtracks, cast recordings etc - to list artists names sometimes
[Artist Covered] - ie [Artist] Mana performing a [Artist Covered] Led Zep song,
[Artist Aliases] - I sort of wound up lumping all my other needs for an additional artist field here, at least for now as I update my library,
so for [Artist] Genesis, say, I list "Collins, Phil;Banks, Tony;Rutherford, Mike"
Then I have another field (also a list)
[Artist List] - sums all the artist fields into one, using
=ListCombine(ListBuild(1,;,[Album Artist],[Artist],[Artist Alias],[Artist Covered],[Artists Featured],[Band],[Composer],[Lyricist],[Orchestra],[Conductor]),)&datatype=[list]
So then I have a view category with the field [Artist Alias] that lists everyone. So if I select, say, "Collins, Phil" - all genesis albums AND all solo stuff AND all compilation stuff comes up, if I want. I dont have time to go over the creation of views but you can get very creative. Just search on the list functions and you should be able to come up
with a lot. Also try searching under nested fields. Hope it helps. There's a lot on this forum, it just has to be found. If I find some links later I'll post them.