Chris,

I assume you want a count of the child records?

Do you have SET SKIP TO ChildTable in your relation?

What is the status of SET("DELETED")? Remember that it is scoped to the datasession.

The most reliable way to get data for reports is to select exactly what you want into a CURSOR and print from there. The data will be denormalized (the parent data will repeat a lot) but it works every time. When you refer to the field in the report use "MyField" not "MyTable.MyField" and just make sure the CURSOR is the current work area.

When you select data into a cursor like that, how does the record count compare to what your report shows?

Post back with more details or questions.


>I am getting an incorrect count in my report. I have two tables a parent table and a child table. In the report there is a group on the key field. In the detail section are the child table fields. In the header section of the group are the parent table fields. I count on the key field in the summary band at the end of the report. When the report is run the count is different from the number of records in the file (it counts more but not enought to equal Parent Recs + child recs). Any suggestions ?????
>
>
>Chris