Forum Discussion

AAbdelkader's avatar
AAbdelkader
Helper I
8 years ago
Solved

inactive relationship Issue

hello there,

 

please, I need help as I got an issue which makes me upset, I've created a relationship between 2 table with another 2 common table as criteria. 

 

 

relationship

 

 

as you see it supposed to be an easy connection, but the Interval table is only connected to Adherence table but the CMS table is not

 

table

 

The file

 

gratefully,

 

  • Hi AAbdelkader,

     

    The cause is the Intervals in CMS are different from the Itervals in Adherence. You can find it when you change the data type into "decimal".

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi AAbdelkader,

     

    The cause is the Intervals in CMS are different from the Itervals in Adherence. You can find it when you change the data type into "decimal".

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • AAbdelkader's avatar
      AAbdelkader
      Helper I

      v-jiascu-msft

       

      Yes yes, how couldn't I notice this?  I'll study the data source for Interval field again.

       

      thanks a lot,