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