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.
:-)