I have set up the conditional formatting. I have an artist and he has done a few series. When I pick the artist, the series come up with the appropriate Foreign Key, BUT when I choose the Series, the number is correct, but the name is not, yet the underlying Foreign Key is correct. Any thoughts on what I am doing incorrecty?
Thanks in advance,