>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only