AnsweredAssumed Answered

Usage Chart Based on Various Records

Question asked by mgxdigital on Oct 25, 2011
Latest reply on Oct 25, 2011 by philmodjunk

Title

Usage Chart Based on Various Records

Post

Hello,

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.

Any ideas?

 

Thanks in advance for any help!

Outcomes