I forgot to mention it is VFP 3.0.

>I have a report based on a view. The view is a one to one
>relationship between 2 tables and a one to many with the
>third. I have used this report in various spots in the
>application with success, but I have added a new tab to
>the pageframe. I append the new record to all three
>tables and issue a tableupdate when the user hits save.
>The records are saved correctly. Then, I issue:
> SELECT * FROM master, parts, sro;
> WHERE master.con_sro_no = m.print_pos AND;
> parts.con_sro_no = master.con_sro_no;
> AND sro.con_sro_no = parts.con_sro_no INTO CURSOR master_sro_view
>
> SELECT master_sro_view
> REPORT FORM pos NOCONSOLE TO PRINTER PROMPT
>
>master table = parent to sro table (one to one)
>sro table = parent to parts table (one to many)
>
>If I have more than one record in the many child table,
>it only prints one record. If I repeat the report command,
>the second command prints correctly. I put a browse in
>my code before I ran the first report and the first report
>command printed correctly. I have tried changing it to
>print "Report form pos for master.con_sro_no =
>parts.con_sro_no. When I have used this report
>before, none of the records where new ones, they were just
>being modified.
>
>Any ideas? Thanks in advance!
>
>Susan