Forum Discussion

kintela's avatar
kintela
Icon for Helper II rankHelper II
9 years ago

ambiguity between tables

Hi I don´t understand why I can not create this relationship between Proyectos and Horas   Each time I try it I get tis message:     In the Horas Table there is no record with proye...
Need Help
kintela's avatar
kintela
Icon for Helper II rankHelper II
9 years ago

But the relationship betewwen Empleados and Proyectos says that one Employee can be group leader of many Projects but one employee that is not group leader of any proyect can work hours in any project.

 

So If I want to know the name of the emoployee that has Hours in the Horas table through his userId I only could get the hours of group leaders throug the filed "jefeGrupo/group leader". No?

 

 

 

 

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
9 years ago

The relationship is there, it just isn't active. 

 

When creating measures you can use the USERELATIONSHIP() function to temporarily activate the relationship between project and hours for the duration of the calculation.

 

Hope this helps

David