Forum Discussion
USERELATIONSHIP is not working - What am I doing wrong?
- 4 years ago
Hi,
This kind of behaviour appears when the relationship is not actually functioning. I recommend checking testing the data types and formatting between the columns. E.g. Here I formatted date column to Text and the relationship broke down:
Back to date format:I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Hi,
This kind of behaviour appears when the relationship is not actually functioning. I recommend checking testing the data types and formatting between the columns. E.g. Here I formatted date column to Text and the relationship broke down:
Back to date format:
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Aha! That seemed to do it! My Debt Recovery Sent Date column was set to Date/Time in the Query Editor, so I changed it to Date & this seemed to do the trick
Thank you so much for your help - lifesaver! 😄
Best wishes,
Helen