First off thanks to everyone for help with Crystal. I too want to put in an extra plug for Craig and his article (http://www.craigberntson.com/Articles/kb010.htm) it was a great beginning point.

Question regarding the database object in the CrystalRuntime.Report object. I have successfully figure out that I can get the source table by the following code.
oTable = CRReport.Database.Tables(1)
This makes oTable the "BORROWER" table that I created from. My question now is how do I determine the number of tables in the database? I designed the test report, so I new there was one, and tried the above code just because it made sense... luckily it worked. But I cannot find a reference to any function that tells me the number of tables in the databse. I want to loop through the tables and call this code:
oTable.SetDataSource(oADODB_RecordSet)
to set the source as the ADODB connection I created for every table. Thoughts?