Struggling with these two tables , should i create another link table or is their a way to concatenate them
on the Budget table, the Period field is the Month field ?
here the problem is that you have a Budget for year 2013 and the transactions are for 2011 and 2012..
you can link them by creating a composite key, but you can't compare your sales with your Budget.
Budget is in financial year, month 3 is period 1, transactions is in calendar date
Month 3 is Periode 1 ? how ?
can you take a look at what I wrote to you and elaborate more ?
I guess il show it as a forecast then
it depends on how it was calculated.. both are estimations.
your key here is the COMPANY_ID and CUSTOMER_ID, so you should use a composite key
Just a sanity check , if one table joins another table using a composite key the model will work , straightfoward .
If 3 or more tables are joined by the same composite key , then one has to use a link table or concatenate the tables where applicable . Is that logic correct
Yes, the logic is correct
Retrieving data ...