What is the different between artist (no “s”) and artists column.
I usually do not show the artists column and this has bit me in the but a couple times. Today is an example. The artist column had Mozart and the artists column had “unknown” and in the column browser section under “Artist” it kept saying I had an artist name of “unknown”.
I finally figured out that the “unknown” was in the artists column and once I blanked the cells wit unknown everything was back to normal.
It seems that artists has precedence over artist so what is the purpose and is there a way to not make it have precedence?
Robert