Usage Chart Based on Various Records
I have a Customers Database and an Orders Database.
The Customer DB holds our customer info and the Orders DB hold our order tickets and packing lists.
I'm wanting to create a layout and put a chart on the layout which will show the total orders shipped each month per whichever customer record you are looking at.
I'm hoping that i can just have one chart and the data could change for each customer.
Currenly, the Customers DB and the Orders DB are connected via a Customer ID field relationship.
Thanks in advance for any help!