Forum Discussion

Pmorg73's avatar
Pmorg73
Post Patron
6 years ago
Solved

Calendar for 2 tables

I have a report that I have created a calendar for. See the relationship view in the image. It is nicely fitlering my invoices over time. but I can not get it to control the billable Time table. If ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi  Pmorg73 ,

     

    As the third - party blog, ‘Both’ setting should be the issue here.Please change the relationship between the tables from both to single and create the relationship between date and Billable to check again.

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi  Pmorg73 ,

 

As the third - party blog, ‘Both’ setting should be the issue here.Please change the relationship between the tables from both to single and create the relationship between date and Billable to check again.

 

 

  • Pmorg73's avatar
    Pmorg73
    Post Patron
    6 years ago

    thanks. I think this has me going in the right direction. I have not quite figured out relationships yet