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