Subreport or 1+ ado's?

[Guest_imported]

I have a similar setup as "mclosson" except I am trying to use multiple "ado"'s. I am trying to show tuples from a "parent" table (as the main recordset for the report) with all the associated child tuples in a different talbe.

Example.

States (ado1)-Cities(ado2)

Texas
Houston
Dallas
California
San Francisco
San Hose
Nevada
Los Vegas

How should I do this? A sub report or two ados?

 

[kenhamady]

I posted an answer in the follow-up to thread 149-70530. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)