Link budget with actual

[vvvvvvizard]

Struggling with these two tables , should i create another link table or is their a way to concatenate them

[YoussefBelloum]

Hi,

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.

[vvvvvvizard]

Budget is in financial year, month 3 is period 1, transactions is in calendar date

[YoussefBelloum]

Month 3 is Periode 1 ? how ?

can you take a look at what I wrote to you and elaborate more ?

[vvvvvvizard]

I guess il show it as a forecast then

[YoussefBelloum]

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

[vvvvvvizard]

Scenario 1

Just a sanity check , if one table joins another table using a composite key the model will work , straightfoward .

scenario

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

[YoussefBelloum · Accepted solution]

Yes, the logic is correct