AnsweredAssumed Answered

Usage Chart Based on Various Records

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


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.

Any ideas?


Thanks in advance for any help!