inactive relationship Issue

[AAbdelkader]

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. 

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

The file

gratefully,

[v-jiascu-msft · Accepted solution]

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]

@v-jiascu-msft, 

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

thanks a lot,