Hey! I need to create an invoice for a customer. I have three tables. Customer, order, product. customer has a one to many relationship with order.
I tried using the report wizard, which worked however all the customers were on the same page which didn't help. After a little research I found that you need to set the force page break to "after section" on the detail part of the form. However, this just put every order on its own page, with only the first order by the customer having customer details.

How can i make it have a page for each customer, with all of the customers orders listed on the page?

any help would be much appreciated!!!

You need to add a group header for customer. Put the customer information into the customer header section. Add another group header for order. Set both headers to page break before.