Hierarchical Recordsets are probably the way to go. Unfortunately, the VFP ODBC Driver cannot be used to create Hierachical Recordsets...:(


>Got it working. I downloaded the latest patch for CRW 6.0 and the report kicked in.
>
>I've got another question. What's the bext way to use ADO and Crystal to report on several tables. Is it to create a view and pass that to Crystal as the record set or to use hierarchial record sets?
>
>Thanks for your help.
>
>Anthony