I'd like to make a customer report that also shows all orders by that customer. I have two tables, a customer table and an order table. The customer table's primary ID is a customer #. In the order table, each line has a customer # from the customer table (lookup wizard to select a # from the customer table), an item and a day. All customers orders are in this order table.
I want to make a report of all customers, showing name, phone number, address from the customer table, then showing all orders for a specfic customer under each customer.
However, when using the Report wizard, I can only select a single line item from the Order table. I'm not sure how to list all Orders for a given customer.
I want to make a report of all customers, showing name, phone number, address from the customer table, then showing all orders for a specfic customer under each customer.
However, when using the Report wizard, I can only select a single line item from the Order table. I'm not sure how to list all Orders for a given customer.
