Problem linking fields after database change

[Varco]

I have some reports that were created and run against a SQL database using an ODBC connection. I need to convert these reports to run natively against a FoxPro database with exactly the same structure and using the ODBC connection. I have converted the driver, and using the Set Location option have changed to the FoxPro database. The problem I have is where i may have had 2 or 3 fields linking beteen tables, now the fields in one table all link to a single field in the other table. Attempyts to delete the incorrect links work fine, when I try to create the correct linkage I get a message stating "Invalid file link. Not all fields in the same index expression". I turned off the option for using indexes for speed on the server, still have the same problem. I am using Crystal V8, any suggestions?

 

[kenhamady]

Try creating a rough of this report from scratch using the FoxPro DSN. Does this allow the proper link?
If not, the problem is the ODBC connection itself.
If it works this way, than the conversion is the problem. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)