>Hi,
>
>I'm building a report that uses two tables, that is, using a parent-child relationship (Parent-->Child). An index has been set up on the Child table.
>This index is being re-created repeatedly when a program (which prepares the data in the Child table) is run. As a result, the P-C relationship set up in the data environment of the report gets broken and the report fails to open.
>I have been able to set up the index(on the Child table) and the relationship into it from the Parent table using code in the program. This works ,that is, thereport opens, but only one record(the first one) from the Child table is pulled into the report.
>
>How can i solve this ???
You need to have the child table selected when you run the report. Make sure you have the parent's alias in front of any fields you use from the parent table.