Page Break

Snoopyc

Hi experts, I have created a printing file based on three tables, Sales Header, Dropship, and Sales Line.
The order number of Dropship will be linked to the No. of the Sales Header, and the order number of the Dropship will be linked to the Document No. of the Sales Line.
Below are the data for the three tables:
Sales Header: P1001
Dropship: P1001, There are two records: Customer Number: A, Address: ABC, Customer Number: B, Address EFG
Sales Line: P1001, There are two items: Line one: Item No.: Pen, Quantity: 100pcs, Line Two: Item No.: Pencils, Quantity: 50pcs

In the printing out, I want to break the page based on the records of Dropship info. Since I have two shipments in the dropship table, the correct printing file will be:

Page One:
P1001

Customer: A
Address ABC
Items: Pens Quantity: 100pcs
Items: Pencils Quantity: 50pcs

Page Two:
P1001

Customer: B
Address EFG
Items: Pens Quantity: 100pcs
Items: Pencils Quantity: 50pcs

But in my printing file, the printing file page break is based on the Line item of the sales line and the page will have four instead of two.

Page One:
P1001

Customer: A
Address ABC
Items: Pens Quantity: 100pcs

Page Two:
P1001

Customer: A
Address ABC
Items: Pencils Quantity: 50pcs

Page Three:
P1001

Customer: B
Address EFG
Items: Pens Quantity: 100pcs

Page Four:
P1001

Customer: B
Address EFG
Items: Pencils Quantity: 50pcs

How to fix it? Thank you in advance!