Forum Discussion
Creating relationship fails with no error message or other output
I've done some more testing and it seems to only be an issue with the one to many relationship type. There are no duplicates in my Date table but I am able to create a many to many relationship without issue, but if I try to change the relationship type to "one to many" it does the same thing, it does a quick load and then nothing happens. No error and no change.
I've created two other tables for testing as well, one where I manually input 4 dates in a column called Date with 2 duplicates, this table can create the "one to many" relationship with no issue.
The second table is a calculated table where I union two sets of dates with some overlapping dates, this table can also create the "one to many" relationship with no issue.
This is the code for the table that won't work
A screenshot of the relationships with the two test tables.