You can have Crystal issue a SELECT statement to pull the data into a single result set or do it in Fox and save the data to an ADO recordset that you pass as a parameter to Crystal or to a Fox2x file that Crystal can then read.

>I am trying to design a crystal report where there are multiple
>tables as the source of the report. Is there a way that I can design a crystal report where I can have multiple tables as the main source
>of the report. In vfp I would have created a select statement with a union
>between the tables into a cursor and have the cursor be the main source file for the report.
>
>Thanks For Your Help !
>Stephen J. Hunt