When I do joins using local TDE files, the color function works as it should. However, when I upload those TDE files to the server, using the color feature isn't working when I place a field from a TDE file other than the primary TDE. The only exception is if I put the field that is the linking field into the color box. Any other fields don't work. It shows a blue color for nulls, and black for all the other varieties. The two TDE files are linked by salesrep name. One file is the main transaction file. The other file is a list of sales reps with various characteristics.