I have the following problem:
I have a table for Clients_ID, each Clients_ID have different amount of certificates listed, for ex.
Client_ID 1 have 5 Certificates so i can create CLIENT_ID as a KEY and CLIEND_ID_CERTIFICATE like 1-1, 1-2, 1-3, 1-4 and 1-5
For each CLIENT_ID I have a Suscribe_Date and for each Certificate I Have other Suscribe_Certificate_Date.
Also i have Billing and Collections table with Billing_Date and Collection_Date.
I have Client_ID for Billing and Collections tables and Billing_ID for each tables too. So I can make a relationship between all the tables with Client_ID as Key Field. And make a relationship between Billing and Collections with CLIENT_ID_BILL_ID as a Key Field only for those tables.
I create a MasterCalendar for each table (Clients, Certificate, Billing and Collections) and a CommonCalendar with the intention of make a MonthYear to create a line chart for view the evolution of Billing and Collections but when i Use the Common MonthYear values are multiplied.