link Date variables

[Luukvoskamp]

Hello,

I have an issue with my data. 

How do i link my data Begroting periode (BudgetMonth) in Jaar(Year) with my calendar so that it links with my costs. 

At this moment I don`t know how to connect these variables to make a year-month-budget-costs table

Hope someone can help me.

Thanks in advance

Luuk

[lanlizgu]

you can create a YEAR-MONTH field in each table so that they could be linked.

[Luukvoskamp]

Does that automatically link to my master calendar as well?

[lanlizgu]

if you have two fields with the same date in two different tables they are linked automatically yes. You need to ensure that both fields data is in the same format so the link could be coherent.