>Thank you Craig for the tip. What if I want to use 2 tables (parent-child) and I need to establish relations ? SQL commands are available only for databases.
Ed gave you a good example. Once you have the cursor created with the SQL SELECT, COPY TO MyTable TYPE Fox2X and then use MyTable for the report.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
