Forum Discussion
luisbarreto
4 years agoNew Member
USERELATIONSHIP not working as expected with date
Dear helpers, I have thought about this problem for many many months and could not find solution. I hope you can help me. My painel has 2 equal calendar tables to bring some information about 2 c...
amitchandak
4 years agoSuper User
luisbarreto , if you have two calendar tables. Then both will have active relationship. what is role of userelationship
Single table joining to two dates needs userelationship
examples
- luisbarreto4 years agoNew Member
Thanks for your reply, amitchandak .
However, my relationships to both calendar tables are already active.
My trouble is when I do two relationships in just one calendar table by using USERELATIONSHIP when I try to link my secondary key (we can't active 2 relationships in the same table with the same column at the same time) to my calendar to get the information I need.
In thesis, it should resolve, it should bring me the right answer (47 workdays) using USERELATIONSHIP with my secondary key. But it doesn't work.