Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Relationship between Calendar table with other tables

I have 3 tables (Headcount, Separations and Calendar) i want to make a relationship of both headcount and separations with a Calendar table. beacuase i want to see the separation and headcount number...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    Basically what that error is complaining about is that the relationship you're trying to create from your tables has issue: One of the Month columns must have unique value of month. You can't have Many to Many relationship but only One to Many or Many to One relationship between them.

     

    In your scenario, I would suggest you to create a new Month table(acts as a middle table) which only contains one column of unique value of month. And first relate your Calendar table to the Month table with the month column, then relate the Month table to Headcount, Separations table.:smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Basically what that error is complaining about is that the relationship you're trying to create from your tables has issue: One of the Month columns must have unique value of month. You can't have Many to Many relationship but only One to Many or Many to One relationship between them.

 

In your scenario, I would suggest you to create a new Month table(acts as a middle table) which only contains one column of unique value of month. And first relate your Calendar table to the Month table with the month column, then relate the Month table to Headcount, Separations table.:smileyhappy:

 

 

Regards