I need help with SCR 8.0 which is connected to an Access 2000 database. I have two table in the Crystal report, "tblMonthlyServiceAnalysis and "tbl2002RVUsw/Mod". There are two fields (both Text) that I want to use to connect the table. The first field is called "CPT" and the second is "MOD". Both fields are present on both tables and spelled the same way. CPT is 5 characters long and Indexed on a "Yes no Duplicates" Index on both tables. MOD is 255 characters long and Indexed again on both tables as "Yes No Duplicates".
When I used the Crystal report Expert it will automatically link up CPT to CPT. -- tblMonthlyService Analysis is on the left and tbl2002RVUsw/Mod on the right. Now when I try to join MOD from tblMonthlyService to MOD on tbl2002RVUsw/Mod I get the message "Invalid File Link. Not All Fields on Same Index Expression"
Any ideas what this means? And how I can get MOD to link to MOD on this report?