>I have a two tables, the parent table with the main information and the child table with the details. Both tables have over 1 million records in them. I created a few programs (2) that will print a report from these tables. In my first program I set a filter on the parent table, indexed the child table and set a relationship from the parent to the child. if the parent record has many child records only one of the child records will print. In my 2nd program i combined the two tables using a SELECT statement. This gave me the correct results but the select takes almost 5 minutes. Is there another method of printing from a one to many relationship?
>
>thank you in advance for your time and efforts

Did you join the tables on indexed column.
I created 2 tables and added 1 million rows each for testing (3 columns each).
The query took too long without using indexes but seconds with indexes.