Sharon,

>I took Walter Meesters' advice and saved some temporary tables used in Crystal reports as foxpro 2x tables. However when I try to link two of them in Crystal, it says it's invalid because the fields aren't indexed, even though they specifically are. Any ideas?

I have encountered much problems when using .CDX index files in CR. I have found the following solution:

When designing you report, make sure the FOX2.X tables are indexed with .IDX files (CREATED BY: INDEX ON Field TO Indexname.IDX). You must specifically add the index to the table in CR (with the add index button).

Make sure that everything works O.K. in the report designer.

At runtime write your FOX2.X tables to a temporary directory (e.g. C:\Temp\_0012345.DBF). Make sure that you write the indexfiles to the same directory. However, be ware that the name of the index must stay the same as used in the report designer. So if you used Article.IDX as name for the index in the CR designer, you must use the same name at runtime, but place it in the same directory as the temporary table (so as: C:\Temp\Article.idx)

IOW, you can change the location and name of a table at runtime, but you can't change any of them of the index directly. CR looks for the indexfile in the same directory as the table.

So then you change the location (and/or names) of the tables with the datafiles or datasource property.

Run the report.

Good luck,

Walter,