Can someone explain how Artists Sort works
I change a single Artist from say Gilels, Emil to Emil Gilels and ALL albums by that artist are changed
As AS is based on a Relational Database logic would suggest a table with a [Sort_Name] column that is then used via INNER JOINS to provide a SINGLE value to all queries that require an ORDER BY [Sort_Name] so why are all albums changed ?