You have a couple of options.

1) Use a PRG to link them, then output to one table. Base the report on the single table.
2) Link the tables in Crystal Reports, then set the Location property of the Table object.

The article on my website shows how to do this.


>Hi,
>
>My application need to be flexible so that I can just distribute my
>rpt file to my customer.
>
>However, my source file are all in *.dbf format which I had encountering some difficult in linking them using the smart link. In this case, I had two different dbf files in different location, how do I link them together.
>
>Plus, each dbf of the above file need to link to each other by three fields, but CR don't allow me to link them together.
>
>So, how do I link them together without hardcoding my database location, (so I think of using ODBC)
>
>Please kindly advise and help. thank you