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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer