I have two tables that I draw from for my Crystal Report. I link the two tables on a common fieldname. The problem is - the field I link from is supposed to be the primary table that I read from to build my report. I don't understand why the field I link to is the one being used to build my report. That throws the report way off. Any idea why the report is using the linked to field as the priamry table and not the linked from table as it should?

Thanks for the help. I don't see what's causing this problem. I will keep looking at it.