>I have inherited some old code...
>Where they take a table and create three different tables via a Select
>statements. Create indexes on each of them. Then they take a different
>table and set relationship to each of the three new tables. Then they
>take a third table and create a relationship to the second table. Then
>they print a report.
>
>Let me see if I can clarify. Three original tables 1) Bank, 2) Daily, and
>3) Transfer. Transfer is the base for create Tran, Tran1, and Tran2
>
>Bank
> |-- Daily
> |---Tran
> |---Tran1
> |---Tran2
>
>I copied the code to a different prg of the same app, and it doesn't work.
>It creates the three tables (with data), sets all the relationships
>but when I scroll through the bank table, the data doesn't refresh
>in the other 4 tables. So the report comes out blank. If I make
>my daily table have the focus, I get my data. But my bank names are
>all the same. I put the bank with the focus and I get all my bank names
>in order but no associated data.
>
>Any help would be greatly appreciated.
>:-)
James
One answer is to make sure that the Data Environment of the form has all of the tables and the relationships established. Check this in the Report Designer.
However a better answer is to create a View from the associated tables and have the Report use this View.
HTH
Précédent
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