Jim,

Let me echo John's advice. You will save yourself a lot of trouble by using the following method.

Select all the data you want for your report into a cursor, exactly the way you want it. Run the report off the cursor. In the report controls, refer to each field as MyField, not MyTable.MyField.


>i needed to rephrase the problem we are having.. we have a parent table with several (3) related child tables. the report has a group defined for the parent data, and the child data items are all located in the detail section of the report. we refer to all the report elements by table.field reference..we have used the set relation to & the set skip to, into each of the child tables, but when previewing the report, only the 1st record from each child table is appearing on report.. it appears that we are not cycling thru all the child records, as we have more that 1 in each child table, but only 1 parent record.
>
>we have all the tables set in the data environment, with a relation set, using our compound key.. alltr(key1)+alltr(key_year1).. if we remove the 2 item of the key in the relation & link only to the key1 item using another index, then we get all the records from the child table..but we need to use the secondary key (which is year).
>
>is there a subreport capability, which allows us to process thru the child records, or is there something we are missing in our setup ???
>
>jah