Hi della!

You're correct, the tables are in the order listed in the tree. However, is isn't necessary to use a TTX file with ADO. The article I posted last night on my web site shows how to use ADO without a TTX file.


>Try this:
>oCReport.Database.Tables(1).SetDataSource(oMyRecordSet)
>
>oCReport is your Crystal Report, and oMyRecordSet is your ADO recordset. If you have multiple tables in your report (which ISN'T a good idea with TTX files, according to Crystal's KB), you can access each table in the tables collection. And from what I can tell, the order they are listed in the Crystal tree is the order you can reference them in the tables collection.
>
> - della