At this moment I have the following tables (which are pulled from CRM):
Master_Calendar (script which enables the use of day, week, month and year inside my project).
From the Visits I created an graph which displays the visits on our domains (current vs previous year (filtered on month)):
Now I want to add an goal for every month, domainname and source. So basically an table which contains: Month, Source, Goal and Domain which is connected to the Table Visits (which also contains domain and Source) and the table Master Calendar to connect the month.
Whenever I try to add more then one key (Source -> Source, Domain -> Domain or Month -> Month) it creates an sync table, how can I avoid this?