I have an application which prints a report from 2 tables. The first table has a document #, seller info and buyer info. The second table has a document # and info about the item(s). Obviously the link is 1 to many from table1 to table2 on the document #. When I preview the report it looks fine. However when I print it from the preview toolbar, I get all of the items in both tables not just the one I selected.
For example: Table 1 doc# buyer seller
123 abc fred
234 bcd jim
345 cde bob

Table 2 doc# item# qty
123 111 10
123 112 1
345 113 4
234 114 5
If I preview doc# 123 report, I see 1 report with 2 items. (As I should.) If I print from the preview I get 3 reports 123, 234, and 345. I don't know why the print button causes all of these reports to print. Any help would be appreciated