>Hi,
>
>Using VFP 7 sp1 I have a report with 3 cursors (not .dbf) that are all related with SET RELATION. One is a 1 to always 1 relationship the other a 1 to 0 or more.
>
>Problem is that the report only shows 1 of the 1 to many. And here is where it gets interesting. If I select the parent, table browse it, then select the many table and browse it. The 1 to many shows up in the browse windows. So, I go back to REPORT xyz PREVIEW and this time the 1 to many works on the report.
>
>Any ideas?
>TIA,
>Cris
After the Set Relation .. Additive
you need to use SKIP TO ChildTable when the ParentTable is active
Tracy