Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Date/Calendar Table

I have a table of dates (every date from 2003 to 2035) in my data model but am wondering if I need to create relationship(s) between this and my other data tables?   If so, my main table has severa...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Create relationships with all the columns you need but make the inactive. Then use USERELATIONSHIP when you want to use them.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Glad to hear that you have worked it out. Would you please kindly share you solution so that it can benefit others having similar requirement?

 

Thanks,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create relationships with all the columns you need but make the inactive. Then use USERELATIONSHIP when you want to use them.