Crystal will use ODBC or OLEDB to access the data. You can issue the SELECT statement there to join the tables.
>I have 5 tables that all have similar information but are not related to each other. Its a court system and the tables are civil dockets, motor vehicle dockets, small claims dockets, criminal dockets, and Local law dockets. Even though all the tables have a docket # in them, they are not related. What I would do if I were using the vfp report writer would join them in a select statement with the join clause then just report off of the resulting cursor. I don't know if -Crystal Reports has anything similar ?
>
>Thanks Again !
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer