Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Printing from two tables
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement